Thanks for the that - excactly what I was looking for.

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


On Mar 22, 2:53 pm, "Bernard Liengme"
wrote:
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
--
Bernard V Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme
remove caps from email

wrote in message

...

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