Thread: how do i make an xy graph start at 0 instead of at 1?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier
 
Posts: n/a
Default how do i make an xy graph start at 0 instead of at 1?
If your first X value is at 1, double click the trendline, and on the
Options tab, in the Forecast box, change backwards to 1.

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


"NeoDS" wrote in message
...
I made a scatter graph, with the origin value at 0. when i made a line of
best fit, the line starts and 1. how do i make it start at 0??


Reply With QuoteReply With Quote