Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
I have a scatter with 2 series.
Series 1 plots "Original GM%" vs "Original Sales". Series 2 plots "New GM%" vs "Sales At New Price". The two series have the same number of points; in each series, a point represents a customer. So every company has two points on the chart, one in series 1 and one in series 2. Is there anyway to automatically connect corresponding points in the two series? I know I can use error bars if only the GM changes or only the sales changes (that is, if a company's point in series 2 is vertically or horizontally aligned with it's point in series 1). But what if a company's sales and GM change - that is, if that company's point moves down and to the left (for instance)? Is there a way to draw that line? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Need diagonal lines behind printed cells. | Excel Discussion (Misc queries) | |||
Drawing Diagonal Lines "Refresh" problem - Any suggestions | Excel Discussion (Misc queries) | |||
How do I add median lines to a scatter chart? | Charts and Charting in Excel | |||
Scatter Chart with Smoothed Lines | Charts and Charting in Excel | |||
How do I place diagonal lines in a cell in Excel. | Excel Discussion (Misc queries) |