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

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

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...
Excel Chart Layouts When you create an Excel chart you can choose from 11 different custom Chart Layouts.This is handy if you are pressed for time and want to create a Chart with all its bells and whistles with a press of a button.From this selection you can show your Chart with or without t...
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 ...
Clustered Bar Chart: Year over Year Comparison If you want to compare products or businesses Year over Year and have category names which are way too long, then the Clustered Bar chart is the one for you.In the example below the category names relate to companies and I am comparing their sales for 2013 and 2014.DO...