Adding symbols or icons into charts can enhance the visual representation, and make it easier to understand the data. In this article, we are going to show you how to use symbols on charts in Excel.

Download Workbook

Adding symbols to Excel

Note that you can always copy a symbol from an external source, and most symbols will work as expected. Let’s see how you can add a symbol into your worksheets in Excel.

You need to open the Symbol dialog to see available options and add what you need.

  1. Start by selecting the cell where you want to insert the symbol
  2. Activate the Insert tab
  3. Click on the Symbol icon in the section Symbols

From this dialog, you can choose the symbol you want and insert into the active cell using the Insert button. For example, arrow symbols can be helpful for visualizing trends in your data.

You can find arrows under the Arrows subset. Different fonts contain symbols with different look-and-feel (especially symbol-based fonts like Webdings or Wingdings). Here are 2 examples:

Arial - Arrows:

Wingdings:

How to use symbols on charts in Excel - Wingdings

Beware while using symbol-based fonts like Webdings. They do not contain Latin letters also they may conflict with numbers. Prefer them if you only want the symbols in your charts.

We will continue with using the Arial arrows in our examples.

Using symbols in your data

There are a couple ways you can add symbols into your chart data. You can add the symbols as is, without them changing dynamically. However, if your symbols indicate a change based on the values, this may not make sense.

For a dynamic structure, you can either use number formatting or formulas. The IF function can be enough in most cases if you only have 2 symbols. If you have more than 2 symbols, VLOOKUP works better.

In this guide, we will mainly be looking at the number formatting method. Excel allows creating your own number formatting beyond adding decimal points or changing currency symbols. You can inject a strings or symbols into the formatting and make Excel display them based on the cell value. A good example is using an up-arrow (↑) for positive numbers, and a down-arrow (↓) for negatives.

Let’s see how you can add symbols into number formatting.

  1. Select the cells of values you want to modify. We added a column that shows the total of each row.
  2. Press Ctrl + 1 to open the Format Cells dialog
  3. Activate the Number tab
  4. Select Custom from the Category box
  5. Add or type in your number formatting into Type. The following example separates positive and negative numbers with a semicolon (;). Also, note that negative numbers do not contain a minus sign (-).
    ↑#,##0.00;↓#,##0.00
  6. Click OK button to apply the formatting.
    How to use symbols on charts in Excel - Number Formatting

This is the result:

If you would like to add colors or other symbols for specific values using number formatting please see: Number Formatting in Excel – All You Need to Know

Using symbols on charts

Finally, we can begin using symbols on charts. We added a total column at the left of the label column. This structure makes Excel evaluate the total column as part of labels. Thus, we can see both the totals and symbols along with the labels.

To add a chart;

  1. Select the data range
  2. Activate Insert tab in the ribbon
  3. Click the icons of the chart you want. We preferred a clustered column chart for this post.

That's it!