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

 

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 **

variance table

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

add data labels

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

format data labels

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.

data label range

Your cool looking chart labels are now on your chart!

chart

Custom Chart Labels

HELPFUL RESOURCE:

Oz_Podcast_Banner

 

 

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

Share on Google+

Google+

Related Posts

Create a Pareto Chart With Excel 2016   Pareto Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the biggest factors in the data set, like seeing which issues are the most common. A Pareto chart, also called a sorted histogram, is a column...
Create a Histogram Chart With Excel 2016 Histogram Charts are one of the many new Charts available only in Excel 2016. They are very visual as it can easily show you the distribution of numerical data, like seeing which numerical ranges are the most common. In this example I show you how easy it is to insert a His...
Dotted Line Organizational Charts You can create Organizational Charts in Excel using SmartArt which I go through in this post here:   Organizational Charts in Excel You can also extend this concept to create a Dotted Line Organizational Chart but we need to think outside the square a little bit to make this h...
Excel Cycle Charts Cycle Charts in Excel are easy to create using the Smart Art feature. There are several cycle process charts to choose from, some have arrows, like the Basic Cycle, and others show the relationship to a central idea, like the Radial Cycle. Here is how you insert a Radial Cy...