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" <Patience@discussions.microsoft.com> wrote in message
news:97110C4B-453B-4DD9-BD89-278474798948@microsoft.com...
> 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