Scatter chart with a trendline

building reports webintelligence
1

Hi,

I’m trying to make a scatter chart (no problem here) but with a trendline.
I can do it with Excel easily but I can’t find how to do it with Webi… :hb: :hb: :hb:

Can anyone help me because I can’t believe that’s impossible to do with Webi.

Thanks a lot :smiley:

mdescalzi (BOB member since 2017-11-08)

2

Not impossible, but D-I-Y:

mikeil (BOB member since 2015-02-18)

3

Thank you for you reply but my problem is how to add the linear trend line to my scatter chart ?..
The scatter chart doesn’t have the “Measure Properties”… :hb:

mdescalzi (BOB member since 2017-11-08)

4

Is there any way in doing it using a line chart stacked on top of the scatter plot with a transparent background? Ive pulled off some interesting things chart stacking like that, although its a pain unifying the axes etc…

ABILtd :uk: (BOB member since 2006-02-08)

5

Thank you for your replies :smiley:
I made the linear trend line with this formulas :

And yes, I can make a line chart with my trend with a transparent background but I have several scatter charts so I can’t unify the axes… And I can’t modify the axes of the line chart to match the axes the scatter chart dynamically… :hb:

mdescalzi (BOB member since 2017-11-08)

6

You can if you create an object to synchronise them. :wink:

7

Oh :o How ? :smiley: :smiley: :smiley:

mdescalzi (BOB member since 2017-11-08)

8

If you look at the max value of the axis, it can use a formula. :slight_smile:

You can apply the same formula to each axis, e.g.

=Floor((Max([Sales Amount]) in Report)*1.1)
9

Thank you for your quick and very useful reply but in the line chart I can’t apply a formule to the axis of abscissas.

Thanks again :smiley:

mdescalzi (BOB member since 2017-11-08)