Create a linear trend line in Excel graphs with logarithmic scale
- by Redsoft7
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