How to Add Asterisk in Excel Graph (2 Handy Ways)

Get FREE Advanced Excel Exercises with Solutions!

To indicate statistical significance, or to show differences between data sets on graphs, Excel should have the option to add asterisks to graphs like bar graphs. In this tutorial, you will learn 2 handy ways to add asterisk in Excel graph.

2 Handy Ways to Add Asterisk in Excel Graph

Letâ€™s first introduce our dataset. We have a table of several fruits items and their respective prices at 3 months, averages, and standard deviation. We have a graph below that shows the standard deviation of different fruits.

Our main goal is to add an asterisk in the graph to show the statistical significance, i.e., we will add an asterisk mark on the column of Lemons that displays the highest standard deviation.

1. Add Asterisk in Graph Using Text Box

Using Text Box, you can easily add asterisks marks on the Excel graph. Just follow the steps below to apply this technique.

ðŸ“Œ Steps:

• First, go to the Insert tab >> Text >> Text Box. A cursor with the text box will appear.

• Now, put the cursor on the column of Lemons in the graph. At this point, from the keyboard, type the asterisk mark into this text box.

• After that, click anywhere outside of the graph. And you will see the asterisk mark where you wanted to add it.

Read More: How to Use Wildcards in Excel?

2. Use Data Labels

Another technique to add an asterisk in Excel graphs is to use Data Labels. Just follow the steps below to use this simple technique.

ðŸ“Œ Steps:

• First, type an asterisk mark in any cell in the worksheet (In this example, (*) at B17).

• Now, select the whole graph, then, click on the Plus sign (+) next to the graph. Choose the Data Labels from the Chart Elements. You can see the labels on each column of the graph.

• Now, double-click on the label of a column on which you want to add an asterisk mark. In this example, we will choose the Lemons columnâ€™s data label. Put the (=) sign in the formula bar, and select the cell (In this example, B17) that contains the asterisk sign. Finally, press ENTER.

Here is the result that shows the asterisk mark on the column of Lemons in the graph. You can increase the font size of the asterisk mark to display it properly.

Related Articles

Hafiz Islam

Hi there. I am Hafiz, graduated from BUET. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. Now you can see my articles in the ExcelDemy blog.

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF