Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-15-2009, 06:50 AM
leroytrolley leroytrolley is offline
Novice
Target line on a excel graph
 
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, 04:19 PM
caholmes caholmes is offline Target line on a excel graph Windows Vista Target line on a excel graph 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

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
Target line on a excel graph Help please: Keeping spaced characters on one line EtienneOBrien Word 3 12-24-2008 07:05 AM
Target line on a excel graph 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

Other Forums: Access Forums

All times are GMT -7. The time now is 04:19 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft