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

Custom Chart Labels Using Excel 2013 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 ...
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...
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...
100% Stacked Bar Chart A 100% Stacked Bar Chart is a great way to compare a percentage that each value contributes to its total. So if we have sales rep sales for three consecutive years, we can plot this on a graph and it will show us what each sales rep´s percentage breakdown is per year. DOWNL...