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

Custom Chart Labels Using Excel 2013 | MyExcelOnline Custom Chart Labels Using Excel 2013 | MyExcelOnline

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 workbookCustom-Chart-Labels.xlsx

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.

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 it
Custom Chart Labels Using Excel 2013 | MyExcelOnline Custom Chart Labels Using Excel 2013 | MyExcelOnline
Founder & Chief Inspirational Officer at

John Michaloudis is a former accountant and finance analyst at General Electric, a Microsoft MVP since 2020, an Amazon #1 bestselling author of 4 Microsoft Excel books and teacher of Microsoft Excel & Office over at his flagship MyExcelOnline Academy Online Course.

See also  Create a Treemap Chart With Excel 2016

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!

Share to...