How to Add an Asterisk in an Excel Graph (2 Methods)

Dataset Overview

Let’s start by introducing our dataset. We have a table containing various fruit items, their prices over three months, averages, and standard deviations. Below the table, there’s a graph displaying the standard deviation for different fruits.

Our objective is to add an asterisk to the Lemons column in the graph, highlighting its highest standard deviation.

Adding Asterisk in Excel Graph

Method 1 – Add Asterisk Using Text Box

Insert a Text Box:
- Go to the Insert tab in Excel.
- Click on Text and select Text Box.

Adding Asterisk in Excel Graph Using Text Box

A cursor will appear, allowing you to draw a text box on your graph.

Adding Asterisk in Excel Graph Using Text Box

Place the Text Box on the Lemons Column:
- Position the cursor over the column representing Lemons in your graph.
- Type the asterisk (*) into the text box.
- Click anywhere outside the graph to finalize its placement.

Adding Asterisk in Excel Graph Using Text Box

Method 2 – Use Data Labels

Type an Asterisk in a Cell:
- In any cell of your worksheet (for example, cell B17), type the asterisk (*).

Using Data Labels

Apply Data Labels to the Graph:
- Select the entire graph.
- Click the plus sign (+) next to the graph (Chart Elements).
- Choose Data Labels.
- Data labels will appear on each column of the graph.

Using Data Labels

Customize the Data Label for Lemons:
- Double-click the data label for the Lemons column.
- In the formula bar, enter = followed by the cell reference (B17) containing the asterisk.
- Press ENTER.

Using Data Labels