Scatter with lines between corresponding points in 2 series?

  • Thread starter Thread starter jg70124
  • Start date Start date
J

jg70124

I have a scatter showing two series:
1) GM% vs revenue by account
2) Pocket margin % vs revenue by account

I'd like to draw lines between the corresponding points in the two
series. For instance, if company A has revenue of 500k and GM% of 39%
but pocket margin of 35%, I'd like to connect the points at (500k,
39%) and (500k, 35%).

Is there an automated way to do that?

Thanks
 
Make a column with GM-Profit and use this a an error bar (just + or -) on
one of the data series
I am sending you a file
best wishes
 
Thanks for the that - excactly what I was looking for.

Sadly, the error bar function crashes Excel 2007 on my machine every
time...
 
Back
Top