J
jg70124
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?
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?