Diagonal error lines in a scatter?
 

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?

Diagonal error lines in a scatter?
 

http://peltiertech.com/WordPress/200...two-xy-series/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
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?

Diagonal error lines in a scatter?
 

Sweet. Thanks

On Jul 22, 9:59 pm, "Jon Peltier"
wrote:
http://peltiertech.com/WordPress/200...two-xy-series/

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. -http://PeltierTech.com
_______

wrote in message

...

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?