Scatter Graph Trendline x=y

[Anonymous]

Hi

How can I create a simple x=y trendline in a scatter graph?

Thanks

A

[tresesco]

Dimension: DimField

Exp1: x

Exp2: y

?

[Anonymous]

Maybe I should elaborate...

I have Product as the dimension.  The first expression is price and the second expression is 12 week average price.  The visual I'm trying to create is where the price is different from the 12 week average price which will highlight where there might be an error in the price entered.  I want a line x=y on the chart to make it even easier to see where the price is different to the average price.

Thanks

[effinty2112 · Accepted solution]

Hi Adrian,

Try this:

Add your two expressions for the x and y co-ordinates of the points.

Add a third expression, 0 (the number zero)

Copy your first expression and paste it as your fourth and add a linear trendline to it.

[Anonymous]

That works, thanks