Thread: how to add a linear trendline to a semi log scale?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
MartinW MartinW is offline
external usenet poster
  
Posts: 860
Default how to add a linear trendline to a semi log scale?
Hi Jt,

If by semi log you mean log scale on the x axis and natural scale
on the y axis or vice-versa, then right click on one of your data
points click add trendline and select logarithmic. This should
give you a line of best fit through your data points.

HTH
Martin


Reply With QuoteReply With Quote