Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I add a target line to a chart? | Charts and Charting in Excel | |||
Goal line? | Charts and Charting in Excel | |||
target line in bar chart | Charts and Charting in Excel | |||
Chart Target Line | Charts and Charting in Excel | |||
Target line | Charts and Charting in Excel |