Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I've created a chart trending our company's daily rank over time. We have a
specific rank as a target goal, and I'd like that to appear as a flat line on the chart, so we know how far we have to go. How can I get such a line, without having to populate a new column with the same number? Thanks |
#2
![]() |
|||
|
|||
![]()
Two options,
1) Simply draw a line where your target is at using the drawing toolbar. 2) Add an additional series to your chart containing two points. The X value of the points indicates the length of your line. The Y values should be set to your target. "Patience" wrote in message ... I've created a chart trending our company's daily rank over time. We have a specific rank as a target goal, and I'd like that to appear as a flat line on the chart, so we know how far we have to go. How can I get such a line, without having to populate a new column with the same number? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Charting data points and show a target range on the same chart. | Charts and Charting in Excel | |||
Urgent Chart Assistance | Charts and Charting in Excel | |||
Urgent Chart Questions | Excel Discussion (Misc queries) | |||
Urgent Chart Assistance Requested | Excel Discussion (Misc queries) | |||
Scrollbar on Chart Jumps to Left when Chart is Clicked | Charts and Charting in Excel |