Scatter with lines between corresponding points in 2 series?

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
 
B

Bernard Liengme

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
 
J

jg70124

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

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Diagonal error lines in a scatter? 2
scatter chart with gaps in series (XL 2007) 7
Points in between Data Series 2
Can I add an average series to a chart with 2 or more series? 4
Discontinuous lines in series due to gaps in data points 2
Excel 2007 crashing with simple scatter plots with 8 k data points 7
In excel scatter plot with 2 series, how do I connect xy coordinat 2
One column and 2 lines chart in single axis 7

Top