How to Add a 45 degree line in a bubble chart with the line starting at (0,0)

user07318

I have a bubble chart with data points comparing two periods in the X and the Y axis. I need to add a 45 degree line to easily categorize the bubbles (SKUs) if they performed better in one period compared to the other. Can someone please help me on this? Thank you! 

RGranada

Hi,

 

I don't think that what you are asking is possible. The closest thing would be the regression lines, but it would not meet your needs i think.

 

Hope this helps.

user07318

Thanks for the reply Ricardo. The regression line won't help as I want a fixed line. 

 

-Ashray 

aussie_dan

Did you ever find a solution to this challenge?  Having the ability to chart a non-regression/non-trendline line that separates performance would be really helpful.

 

Cheers!

user07318

Haven't found a solution yet. 

rahul93

Hey, 

I am not sure what you mean by a 45 degree line. If you mean horizontal line you can do so by going to the quadrant lines option and setting a value on the y axis scale. 

This will give you a horizontal fixed line based on the values you are using on your y axis. 

Hope this helps. ?