Programming drawing obj. to center around value on graph
 

Is it possible to have a rectangular drawing object to center itself around a
value plotted on a graph. I would like to have a rectangle representing two
standard deviations centered around a value on a normal curve. Suggestions?

Programming drawing obj. to center around value on graph
 

First, it will be hard to maintain the 2 SD height and width if anything
adjusts the width or height of the chart area, or the axis scaling. But
second, you can center your shape on a point easily. Plot another point (a
new XY series) with the same X and Y values, then copy your shape, select
the point, and paste. The shape becomes the new custom marker for the point.
Here's mo

=if(C25="",N/A(),Sum(C22:C25))

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

"Jeff" wrote in message
...
Is it possible to have a rectangular drawing object to center itself
around a
value plotted on a graph. I would like to have a rectangle representing
two
standard deviations centered around a value on a normal curve.
Suggestions?

Programming drawing obj. to center around value on graph
 

That's just about what I want to do. As I paste the rectangular object onto
the data point however, it is perfectly centered and I would rather the
rectangle not hang down below the x-axis. I would like the rectangle to
extend above the x-axis however. Suggestions?

"Jon Peltier" wrote:

First, it will be hard to maintain the 2 SD height and width if anything
adjusts the width or height of the chart area, or the axis scaling. But
second, you can center your shape on a point easily. Plot another point (a
new XY series) with the same X and Y values, then copy your shape, select
the point, and paste. The shape becomes the new custom marker for the point.
Here's mo

=if(C25="",N/A(),Sum(C22:C25))

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

"Jeff" wrote in message
...
Is it possible to have a rectangular drawing object to center itself
around a
value plotted on a graph. I would like to have a rectangle representing
two
standard deviations centered around a value on a normal curve.
Suggestions?