Hi,

Add 2 data series. Change both new series to stack bar chart.
The first of these new series should have a value equal to the lowest
value. The 2nd should have a value equal to the width of the shaded area.
In order to complete the chart you will need to,
Format the 1st series to have no fill or border.
Format the 2nd series to have no border, Yellow fill, Series Options Gap
Width of zero.
Format secondary x axis to have the same min and max scale values as the
primary x axis.

Cheers
Andy

Jeff wrote:
I would like to have a rectanglar drawing object representing two standard
deviations shown and automatically move around a value on a normal curve. I
have plotted a second point in the graph referring to the IQ score and have
copied a shape to become the new custom marker for the point so that the
rectangle shows an area about 2 standard deviations around the IQ. However,
the custom marker hangs below the x-axis, whereas I would prefer that it not
hang down below the x-axis. I would like the rectangle to extend above the
x-axis however. Suggestions?

Below is a link to the file I'm working on as well. Any help would be
appreciated.

http://www.geocities.com/jeff_k.geo/NormalCurve.xls

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info