View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default How do I stop trendline from touching the y-axis?

Does the leftmost point have an X value of zero? Did you choose the option
to force the fit to pass through the origin?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Marco Couch" <Marco wrote in message
...
I have plotted a few points in a scatter graph and need to add a linear
trendline, however everytime I do, it extends the trendline to the Y-Axis,
which makes my plots unclear and very bunched up.
I want to be able to add a trendline without it touching the y-axis.