Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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,