Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

LinkBack Thread Tools Display Modes
Old 01-15-2009, 06:50 AM
Join Date: Jul 2008
Posts: 11
leroytrolley is on a distinguished road
Default Target line on a excel graph

I have created a lovely looking bar graph on Excel, but i would like to include a target line so I can see how much over or under the target my bars are.

I have used a free hand line in the past, but i am wondering if there is a more precise way of doing this.
Reply With Quote
Old 01-16-2009, 04:19 PM
caholmes caholmes is offline Windows Vista Office 2007
Advanced Beginner
Join Date: Dec 2008
Location: Sydney, Australia
Posts: 54
caholmes is on a distinguished road
Default Target line on a excel graph

You will need to add a new series of data. This data will ultimately be used to be displayed as a target line in your chart. So the new series of data will be all the same values (the value of the target you are trying to set) see example below:
Jan Target
Week1 ____75__ 50
Week2 ____83__ 50
Week3 ____45__ 50
Week4 ____65__ 50

Add the new data to the source data for the chart. This will be displayed as an additional column/bar in your chart. Right click on one of the new columns and select chart type and then set it to a line chart type. This will give you the desired result.
Reply With Quote

Thread Tools
Display Modes

Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot delete line adkr Office 1 04-07-2010 09:26 PM
Help please: Keeping spaced characters on one line EtienneOBrien Word 3 12-24-2008 07:05 AM
Multiple styles on same line in Microsoft Word jhopppppp Word 2 12-05-2008 10:16 AM
character per line problems in Word 2007 JLStreet Word 0 02-13-2008 06:50 AM
Print error OE6- script line 1344 HJJC Outlook 11 12-10-2005 09:43 AM

All times are GMT -7. The time now is 07:12 AM.

Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc. is not affiliated with Microsoft