topic Re: Median line on scatter chart in Water Cooler

Median line on scatter chart

Thu, 03 Jul 2014 08:23:45 GMT

How can i add 1 line of median into the scatter chart below?izzit possible??

I hope to get the result shown as below. The median line can across all the point but the remainded point should be there also....

whiteline — Thu, 03 Jul 2014 09:43:10 GMT

Hi.

Properties -> Presentation tab -> Reference Lines -> Add -> Type expression and choose the axis.

Fri, 04 Jul 2014 00:20:09 GMT

This is what i did.....but still unable to add the median line...izzit my wrong??

whiteline — Fri, 04 Jul 2014 12:59:33 GMT

Hi.

The reference line is always horizontal.

Use trendlines feature on expression tab if you want to show linear regression.