Add target to trend chart
 

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

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