fixed Line

A

ArturoCohen

Hi all.
How do I get a fixed line in a graphic in excel 2000, I have a trend
and i need to mark the goal, with a line that remais unvariable fixed
at 90%.

Thanks for your support
 
M

MartinW

Hi Arturo,

Not a lot of information to work with there, but try this.
Add a series to your chart that references two cells, the first cell has
your
x value = 90 and the second has your y value = (a calculation that returns
the same value as your trendline when x=90).
Then you can format the series error bars to show a line from the series
point back to the axis line.

HTH
Martin
 
Top