| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Shaded area between 2 scatter points? | Charts and Charting in Excel | |||
| Discontinuous lines in series due to gaps in data points | Charts and Charting in Excel | |||
| Scatter plot points x and y coordinates | Charts and Charting in Excel | |||
| referencing lines and series points | Charts and Charting in Excel | |||
| Data Points in Scatter Chart | Charts and Charting in Excel | |||
Linear Mode
