Show Trend Arrows in Excel Chart Data Labels

Watch Video – Show Trend Arrows in Chart Data Labels

Excel chart data labels are quite boring. While there is not much you can do with these, a bit of excel trickery can add some glamor to it. In this post, I will show you how to show trends in chart labels in a bar chart. Something as shown below:

Excel Chart Data Labels - Show Trend

Show Positive/Negative Trend Arrows in Excel Chart Data Labels

Suppose I have the data as shown below:

Excel Chart Data Labels - Data Set

If I plot 2013 data only, it won’t tell us how much the sales of a product have increased/decreased over the last year. However, I can do this by changing the chart data label to show the YoY change. To do this, we first need to modify our data set a bit.

Excel Chart Data Labels - Data Set with Arrows

Changes made to the data set
  1. Added YoY change in Column D
  2. Added an upward arrow in B11 and downward arrow in C11
    • To do this, go to Insert –> Symbol
    • In the Symbol dialog box, select Arial font (or whatever you are using), and scroll down to find the arrow symbols
  3. In column E, use the following combination of TEXT and IF formula:
=TEXT(D3,"0.0%")&IF(D3>0,$B$11,$C$11)

When you have the data set in place, create a bar chart using 2013 values. You will get a chart as shown below:

Excel Chart Data Labels with Regular Chart Labels

Now to show the YoY change instead of 2013 values in chart labels, follow the steps below:

For Excel 2013
  1. Click on any of the data labels
  2. Right-click and select Format Data Labels
  3. In Label Option, check Value from Cells, click on Select Range and select the cells the new labels (E3:E9 in this case)
    Excel Chart Data Labels - Format Data Labels Excel 2013
For Excel 2010
  1. Select the first data label (click on it twice)
  2. Click on the formula bar and type =
  3. Select E3
  4. This will change the first data label to display the value in E3 (along with the arrow). Now you can do this for all the data labels (a bit of manual labor – but a straight forward method)

That’s it!! You would have your chart ready.

Excel Chart Data Labels with Trends in Chart Labels

Try it yourself.. Download the file
Download File Pic

You May Also Like the Following Excel Tutorials:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

8 thoughts on “Show Trend Arrows in Excel Chart Data Labels”

  1. I have the same problem as Chris Macro
    I can’t figure out how to insert the arrow symbols into Excel 2016 as Insert > Symbol only gives me 255 Arial characters, none of which are the arrows.
    =CODE(B11) returns 63, which is the Arial Question Mark.
    However, if I copy the arrows from your example file into 2016 it works perfectly!

    Reply
  2. Hi Sumit, Thanks for the amazing video. I just had a confusion, can you help me in adding the colored up and down arrow in the chart, currently it only black in color.

    Reply
  3. Can you insert the arrow symbol in Excel 2007? I can’t figure out how to insert the arrow symbols (see dialog in attached picture) but if I copy the arrows from your example file into 2007 it works perfectly!

    Reply
    • Hi Chris.. This is weird.. I don’t have 2007 (have 2010 and 2013). Let me get hold of a machine with 2007 and check this out. But if these arrows are not in 2007, the one at the bottom left of this picture should work the same I guess 🙂

      Reply
      • thanks alot for the tip. i have a bubble chart and would like to add trend up / down arrows against the bubbles to denote if there is a increase or decrease in the value.

        Reply
  4. This is a cool trick! I’ve used it several times. However, it is very tedious to go over each data label to change it. Do you have some VBA code to change the labels automatically?

    There’s an add-in that you can use for scatterplots (X-Y plots) but I’m not aware of any add-ins for column charts.

    Reply

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster