View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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?