how do i make an xy graph start at 0 instead of at 1?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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??
 
I will assume that "made a line of best fit" means you added a
trendline. If so, double-click the trendline. In the resulting dialog
box, from the Options tab, check 'Set Intercept to' and enter zero in
the adjacent textbox.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
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/
_______
 
thank you for you help, but i need the trend line to be a cuve, and when i do
that it won't let me to set the intercept.
 
Back
Top