View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default how to add a linear trendline to a semi log scale?

If you want a fitted line to be straight on a semilog plot, you need to fit
the data to an exponential trendline. A linear fit curves downward due to
the shrinking of the scale at the top of the log scale.

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


"jtlurk" wrote in message
...