Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark in a graphical way, highlighting the strong v weak months.

I will show you how to do this using Using Excel 2010.

DOWNLOAD EXCEL WORKBOOK

STEP 1: Enter your data into three columns, the month, the actual sales and the benchmark sales

STEP 2: Click inside your data and go to the ribbon and choose Insert > 2-D Clustered Column

STEP 3: Select the Benchmark series chart and Right Click and choose the Change Series Chart Type

change chart type excel 2010

STEP 4: This will bring up the Change Chart Type dialogue box and you will need to select Line and Line with Markers

change chart type to line excel 2010

STEP 5: Click on the line chart and press CTRL+1.  This will open up the Format Data Series dialogue box

STEP 6: Select the Marker Options and choose Built In, select the horizontal line type and increase the Size to 10.  You can also format the color of the line.

marker options excel 2010

STEP 7: Select the Line Color and choose No Line and press OK!

line color excel 2010

Benchmark Chart Excel 2010

HELPFUL RESOURCE: 

Bill_Jelen_Podcast_Banner_EXCEL

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

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...
Create a Waterfall Chart With Excel 2016 Waterfall Charts are one of the many new Charts available only in Excel 2016. They are very popular in the current corporate environment as they graphically show the positive and negative movements within your Monthly Net Profit or Cash Flow. When I was working at General E...
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...
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...