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

Organizational Charts in Excel Organizational Charts are important in any business and documenting them is very easy to do within Excel and in particular, SmartArt. To create an Organizational Chart in Excel you have to go to the ribbon menu and select Insert > SmartArt > Hierarchy > Organizational...
Logarithmic Scale In An Excel Chart When you have a large numerical range of data and you want to plot a graph, you will most probable end up with a skewed looking chart like the one below: You can use the logarithmic scale (log scale) in the Format Axis dialogue box to scale your chart by a base of 10. W...
Sparklines: Line Sparklines are new in Excel 2010 and they show a graphical representation of your data in one cell. You can style them in different colors and add a marker for the High and Low points of your data.  As your data changes so do the Sparklines, which gives them that much more pow...
Stacked Column Chart: Compare Contributions The Stacked Column chart is used in Excel to compare the contribution of a value to a Total. For example, if you want to show the North & South sales for the last 5 years then this is the chart for you as I explain below. NB: If you are using Years as your first column ...