Create a linear trend line in Excel graphs with logarithmic scale

Posted by Redsoft7 on Super User See other posts from Super User or by Redsoft7
Published on 2014-08-19T12:14:51Z Indexed on 2014/08/20 16:25 UTC
Read the original article Hit count: 230

I I have an Excel scatter chart with x and y values. I set the logarithmic scale in x-axis and y-axis.

When I add a linear trend line to the graph, the line is not linear but appears like a curve.

How can I make a linear trend line on a logarithmic-scaled chart?

Sample data:

x:
18449
22829
25395
36869
101419
125498
208144
2001508
14359478
17301785

y:
269,09
273,89
239,50
239,50
175,13
176,73
151,94
135,15
131,55
121,55

© Super User or respective owner

Related posts about microsoft-excel

Related posts about microsoft-excel-2007