trendline going below points in the chart

[Brad White]

I have a burndown graph, so the trendline has a negative slope.
I'm only interested in the X-intercept.
How do I keep the trendline from exceeding the normal bounds of the chart?

When it goes down to -2000, it shrinks the rest of the chart
so that it can't be seen and is useless.

Thanks,
Brad.

 

[Jon Peltier]

Brad -

You can double click on an axis, and on the Scale tab of the dialog box
that pops up, set the axis minimum and maximum that you want. This
prevents data series or trendlines from redrawing the chart scales.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[Brad White]

That fixed it.

I was trying to do it from the trendline.

Thanks,
Brad.