Pinterest Pixel

Custom Chart Labels Using Excel 2013

In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

In a previous blog post we created a Benchmark Chart using Excel 2013.  We are going to extend this concept and add some cool looking custom chart labels to make our chart more informative.

View the Benchmark Chart using Excel 2013

Custom Chart Labels Using Excel 2013 | MyExcelOnline
DOWNLOAD EXCEL WORKBOOK

STEP 1: We added a % Variance column in our data and inserted symbols ▲▼ to show a negative and positive variance

** You can see the tutorial of how this is done here **

Custom Chart Labels Using Excel 2013

STEP 2: In our graph we need to select the Sales chart and Right Click and choose Add Data Labels

Custom Chart Labels Using Excel 2013

STEP 3: We then need to select one Data Label with our mouse and press CTRL + 1 to bring up the Format Data Labels dialogue box

STEP 4: From the Format Data Labels dialogue box we need to select the Value From Cells box only and make sure no other boxes are ticked

Custom Chart Labels Using Excel 2013

STEP 5: This will bring up a Data Label Range dialogue box.  If it does not show, then you need to select the Select Range… button.  From here you need to select the Variance data range and press OK.

See also  Combine Column & Line Charts in Excel

Custom Chart Labels Using Excel 2013

Your cool looking chart labels are now on your chart!

Custom Chart Labels Using Excel 2013

 

Unpivot Data Using Excel Power Query

 

 

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Pinterest

Share on Facebook

Facebook

Tweet about this on Twitter

Twitter

Share on LinkedIn

Linkedin

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!