Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Scatter Plot - Glitch with Trend Lines using a Logged Scale?

I have a scatter plot where I need to log the scale otherwise the outliars make the visual extremely unappealing (however these values still need to be included)

Without logging the scale the trendline (for "average) works perfectly fine; however once I log the scale the trendline goes way below all of the other values.

Once logged, the trendline is at at the value for 20 when 95% of values are between 700-1200, only one or two are even below 20.

Is this a glitch? How can I fix it?

1 Reply
Not applicable
Author

I'd like to add that when I click show equation it shows that Y = 1100.3, yet the line is still at the 20 level, well below everything on the chart.