LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default Creating a goal or target line

I am using a line graph to show my weekly percentages for the year. I have a
goal of keeping these percentages below a specific value. I would like to
have a line across my graph at that specific goal value so I can see which
weeks have exceeded my goal percentage or have remained below it. Is there an
easy way to do this? Also, if possible, I would like my data line to change
color as it crosses that goal line. For example, the line would be black
below that specific goal value, but when the line crosses that goal value it
would turn red. Any suggestions?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I add a target line to a chart? soconfused Charts and Charting in Excel 1 June 15th 07 02:52 PM
Goal line? TJH Charts and Charting in Excel 1 February 14th 07 11:21 AM
target line in bar chart chinascot69 Charts and Charting in Excel 1 July 28th 06 12:50 PM
Chart Target Line AlDeb Charts and Charting in Excel 1 October 11th 05 05:29 PM
Target line Pat Jennings Charts and Charting in Excel 2 January 28th 05 12:58 PM


All times are GMT +1. The time now is 05:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"