trendline going below points in the chart

  • Thread starter Thread starter Brad White
  • Start date Start date
B

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.
 
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/
_______
 
Back
Top