Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Can I add a curved reference line to a scatter chart?

I have created a scatter chart that show the stock value (Y axis) and how many times it turns a year (X axis) refer attachment

nb: the optimal number being: value x turns = 1.2.

What I would like to acheive is a chart that includes a curved reference line (or similar type line) that: Y axis * X axis = 1.2

Thank you

1 Reply
Oleg_Troyansky
Partner Ambassador/MVP
Partner Ambassador/MVP

Tara,

I'm not sure if it's possible within the boundaries of a single chart, but you can try to overlay two charts - the scatter and a line chart. The tricky part is to keep their Axis scales identical...

cheers,