Pinterest Pixel

Benchmark Chart in Excel 2010

Benchmark Charts or Budget Charts are a great way to show your actual sales versus your benchmark... read more

Download Excel Workbook
John Michaloudis
Posted on

Overview

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.

Benchmark Chart in Excel 2010 | MyExcelOnline
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

Benchmark Chart in 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

Benchmark Chart in 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.

See also  How to Make a Graph in Excel - Make Your Data Talk With Visual Charts!

Benchmark Chart in Excel 2010

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

Benchmark Chart in Excel 2010

 

HELPFUL RESOURCE: 

Vlookup in an Excel Table

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

Get Video Training

Advance your Microsoft Excel & Office Skills with the MyExcelOnline Academy!

Dramatically Reduce Repetition, Stress, and Overtime!
Exponentially Increase Your Chances of a Promotion, Pay Raise or New Job!

Learn in as little as 5 minutes a day or on your schedule.

Learn More!