Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

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

Hi
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.
Leroy
Reply With Quote
  #2  
Old 01-16-2009, 03: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
Reply
Please reply to this thread with any new information or opinions.

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 06:05 AM
Multiple styles on same line in Microsoft Word jhopppppp Word 2 12-05-2008 09:16 AM
character per line problems in Word 2007 JLStreet Word 1 03-05-2008 11:23 AM
Print error OE6- script line 1344 HJJC Outlook 11 12-10-2005 08:43 AM


All times are GMT -7. The time now is 10:57 PM.


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