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

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.

How to Add Asterisk in Excel Graph: 2 Handy Ways

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 asterisk 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 Add Arrow in Excel Graph

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.

The result 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.

Download Practice Workbook

You can download the practice workbook that we have used to prepare this article.

Conclusion

In this tutorial, I have discussed 2 handy ways to add asterisk in Excel graph. I hope you found this article helpful. Please, drop comments, suggestions, or queries if you have any in the comment section below.

Related Articles

• How to Center a Chart in Excel
• How to Left Align a Chart in Excel 
• How to Add a Vertical Dotted Line in Excel Graph
• How to Add Vertical Line in Excel Graph
• How to Add Border to a Chart in Excel
• How to Remove Chart Border in Excel

<< Go Back to Formatting Chart in Excel | Excel Charts | Learn Excel