Scatter with lines between corresponding points in 2 series?
 

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

Scatter with lines between corresponding points in 2 series?
 

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 MVP
http://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

Scatter with lines between corresponding points in 2 series?
 

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

Scatter with lines between corresponding points in 2 series?
 

I do not have that trouble.
Wonder if other do? I will start a new thread
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

wrote in message
...
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