I've got the following data plotted on an X-Y chart:
The trends plot just fine, and are obviously logrithmic. However, when I try to add a trendline and get the logrithmic equation for the line, that option (as well as the power option) is grayed out.
If I change the chart to a logrithmic type, all options for trendlines are available and the equation is correct (I checked by hand).
I would really like to display it on a linear chart with a logrithmic trendline. It's mostly for aesthetic purposes than for anything else. Any thougths on what I am missing?
Thanks,
K
Code:
Time X1 X2
0 29.32 59.39
3 30.94 56.98
6 32.85 54.34
9 33.53 52.58
12 34.73 51.53
15 35.57 50.45
18 36.21 49.72
21 36.87 49.39
If I change the chart to a logrithmic type, all options for trendlines are available and the equation is correct (I checked by hand).
I would really like to display it on a linear chart with a logrithmic trendline. It's mostly for aesthetic purposes than for anything else. Any thougths on what I am missing?
Thanks,
K