Why is a logarithmic not always an option under trendline type?

G

Guest

I have 22 plots that are all a similar, logarithmic shape, yet only three of
them give me the option to add a logarightmic trendline.

The plots where the logarithmic trendline does work are perhaps closer to a
true logarithmic shape than those where it does not work, but not by much.

Does the logarithmic trendline only work when the shape is very close?
 
A

Andy Pope

Do you have zero or negative x values?
I have 22 plots that are all a similar, logarithmic shape, yet only three of
them give me the option to add a logarightmic trendline.

The plots where the logarithmic trendline does work are perhaps closer to a
true logarithmic shape than those where it does not work, but not by much.

Does the logarithmic trendline only work when the shape is very close?
 
G

Guest

at the start of each plot, there were a bunch of x values around zero, some
positive, some negative, some zero, but my plot was formatted so that i
didn't see negative values cause they were inconsequential. thanks a lot for
your help, i couldn't figure it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top