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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

Save A Chart Template Saving a Chart template in Excel is an efficient way to reuse your favourite or your company´s standard chart template.So whenever you have new data and want to create a chart with your (company´s) standard formatting, all you need is a couple of clicks and you will have it s...
Line Chart: Trend with lots of data A Line Chart is used in Excel when you have lots of data points and want to show a periodic trend.An example can be company sales over the last 20 years, daily transactional sales results for the year, interest rate evolution or the population growth from the year 1900, as I ...
Thermometer Excel Chart Thermometer Charts are one of the many Charts you can create in Excel.  It does not really exist in Excel, however we can get creative and create our own.A Thermometer Chart gives you a good view of the percentage of progress made on your project, budget etc.We are going ...
100% Stacked Column Chart: Percentage Contribution... The 100% Stacked Column chart is an extension of the Stacked Column chart in that it compares the percentage that each value contributes to a Total.For example, if you want to show the percentage contributions for the North & South sales over the last 5 years then thi...