Programming drawing obj. to center around value on graph

[Guest]

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?

 

[Jon Peltier]

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 more:

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

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

 

[Guest]

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?