Get The Completed Workbook

Adding symbols into your tables or charts can be a great visual aid to your numbers. In this example we’ll look at how we can add up and down arrows into our number formatting to show increases or decreases in our data. The symbols we’re going to use are unicode characters which are actually a standard across any platform and are available on any language PC.

 

Step 1: Accessing Symbols in Excel

 

Step-001-How-To-Use-Symbols-To-Enhance-Your-Tables-And-Charts How To Use Symbols To Enhance Your Tables And Charts

 

We’ll need to insert the symbols we want to use into our workbook.

  1. Select an empty cell to insert the symbols into.
  2. Go to the Insert tab in the ribbon.
  3. From the Symbols section, press the Symbol button.
  4. Select Arial from the Font drop down list.
  5. Select Geometric Shapes from the Subset drop down list.
  6. Select the arrow.
  7. Press the Insert button. Select the arrow, and press the Insert button again.
  8. Press the Close button.

 

You can now use these symbols later by copying and pasting them from the cell you inserted them into.

 

Step 2: Adding Symbols To Your Table Formatting

 

Step-002-How-To-Use-Symbols-To-Enhance-Your-Tables-And-Charts-1024x514 How To Use Symbols To Enhance Your Tables And Charts

 

We can add symbols into our table data using cell formatting.

  1. Select the data from your table where you want add symbols.
  2. Right click and select Format Cells from the menu. You can also access the Format Cells menu using the Ctrl + 1 keyboard shortcut.
  3. Go to the Number tab in the Format Cells menu.
  4. Select Custom from the Category.
  5. Add this format code to the Type. or modify it with different symbols you might have chosen in step 1.
    [Green] ▲ 0.0%;[Red] ▼ 0.0%

    This will format positive numbers as green with a up arrow in front and negative numbers as red with a down arrow in front.

  6. Press the OK button.

 

Step 3: Add A Bar Chart Using Your Data

 

Step-003-How-To-Use-Symbols-To-Enhance-Your-Tables-And-Charts How To Use Symbols To Enhance Your Tables And Charts

 

Charts will automatically take on the formatting of the data used so our chart will also have a nice visual appeal.

  1. Select your data.
  2. Go to the Insert tab in the ribbon.
  3. From the Charts section, press the small Bar Chart icon.
  4. Select the 2D Bar Chart from the menu.

 

Step-004-How-To-Use-Symbols-To-Enhance-Your-Tables-And-Charts-1024x569 How To Use Symbols To Enhance Your Tables And Charts

 

If your bar chart doesn’t contain the symbols then you can add them in.

  1. Here we can see the symbol formatting in our chart. If it’s not already there, click on the chart.
  2. Go to the Design tab.
  3. From the Chart Layouts section, select the Quick Layout button.
  4. Select your preferred layout.

 

Step-005-How-To-Use-Symbols-To-Enhance-Your-Tables-And-Charts-1024x524 How To Use Symbols To Enhance Your Tables And Charts

 

Now you have a cool graph with easy to see information about the change in sales since last year. The formatting is dynamic so if you update your data the symbols in the table and graph will update accordingly.