Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
How can I create a simple x=y trendline in a scatter graph?
Thanks
A
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.
Dimension: DimField
Exp1: x
Exp2: 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
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.
That works, thanks