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.

There are a few steps but in Excel 2013 it has been made much easier to create these charts with the new Combo charts.

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 series chart type

STEP 4: This will automatically take you to the Combo chart box and you need to select the drop down for the Benchmark and select Line with Markers

line with markers

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

STEP 6: Select the Line option and choose No Line

no line

STEP 7: 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 Benchmark Chart

HELPFUL RESOURCE:

MOTH 468x90.update.your.skills.animated.chart.learn.online.2

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

Excel Chart Marker Options The Marker Options within an Excel chart enables you to add different marker types or shapes on your chart to distinguish a data series or its individual data points. To bring up the Marker Options you need to click on your Excel chart and make sure that all the points are sel...
Add High & Low Points in an Excel Sparkline Sparklines are a great way to visualize lots of data quickly.  Differentiating the High and Low points within the Sparkline pinpoints your strong and weak data points. To enter a High or Low marker you need to click inside your Sparkline which will activate the Sparkline Tools...
Pie Charts in Excel Pie Charts are used widely in the Microsoft Excel community but for the wrong analysis. Even though pies are delicious!, a Pie Chart should only be used to show several parts that make up a whole, for example, a product cost breakdown, margin breakdown or the market share of c...
Benchmark Chart in Excel 2010 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 ...