trendlines in scatter charts

Report Inappropriate Content · ‎2013-05-13

Hi all,

I have to put two trendlines in a scatter chart. The second expression (horizontal line?) is easy to make by clicking average, but for the first expression (vertical line?) this opinion is enabled. So I tried to define a "reference line" in the presentation tab, but it doesnt't work. The expression is shown below. Can anyone help?

sum(aggr ( max ( if (QuestionID='Q3B',$(vWeight)

vikasmahajan · ‎2013-05-14

Please attach your demo application

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Report Inappropriate Content · ‎2013-05-14

Hi Vikas,

the demo is attached above. The "wrong" try is red and to be found under presentation/ reference lines.

If you need further information, please ask.

Thanks

Alex

Report Inappropriate Content · ‎2013-05-24

Hi Vikas,

have you seen any chance to create a horizontal average?

Or is it just impossible in this case?

Thanks a lot

Alex

Related Topics