View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
[email protected] jg70124@gmail.com is offline
external usenet poster
 
Posts: 9
Default 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