4 Replies Latest reply: Nov 26, 2015 4:27 AM by Adrian Buzer

# Scatter Graph Trendline x=y

Hi

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

Thanks

A

• ###### Re: Scatter Graph Trendline x=y

Dimension: DimField

Exp1: x

Exp2: y

?

• ###### Re: Scatter Graph Trendline x=y

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

• ###### Re: Scatter Graph Trendline x=y

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.

• ###### Re: Scatter Graph Trendline x=y

That works, thanks