Logarithmic trendline unavailable

[Kevin Becker]

I have an X-Y scatterplot and would like to plot a
trendline. The physics of the problem imply a logarithmic
decay. When I try to add a trendline, the logarithmic
option is not highlighted and hence unavailable to
choose. I have similar graphs on a different worksheet
page where the logarithmic trendline is available and
works fine. Any idea why the logarithmic trendline is
unavailable and how to address?

I can change the x-axis to a log scale and Lotus 123 will
provide me with logarithmic trendlines for the exact same
data, so the problem does not appear to be caused by
invalid data points.

Thanx for your help.

 

[Dan E]

Kevin,

This may or may not work.

Try switching around the series...
ie make the current X series the Y series and the current Y
series the X series.

I know it sounds ridiculous, but it has worked for me in the
past.

Dan E

 

[Bernard Liengme]

Could we see some of the data please?