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

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...
Excel Chart Template Infographic Excel Charts are great but there are so many to choose from that sometimes its hard to decide which one goes well with your data.The Infographic below (scroll down) helps you decide which Excel chart to use based on the data that you have and message that you want to convey. ...
Create a Sunburst Chart With Excel 2016 Sunburst Charts are one of the many new Charts available only in Excel 2016.They are very visual as it can easily show you hierarchical data, like having a table with different levels of categorization:Each hierarchy is drawn by one ring in the sunburst chart. The inn...
Bubble Chart: 3 Variables On A Chart A Bubble Chart is an extension of the XY Scatter Chart.  It adds a 3rd variable to each point in the XY Scatter Chart.For example, if you have a Scatter Chart that shows the relationship between the age of a house and its proximity to the city and want to add the value of...