I've never tried that, but I'm sure it's possible. Let's assume your
primary X axis values are Z scores from say -6 to +6 and you want to include
the Mean.

You'll need another series of data with

X Y Label (Mean)
-6 0 Mean for Z=-6
-5 0 Mean for Z=-5
and so on.

Plot the X and Y axis labels on the chart. These will eventually be made
invisible so don't worry about the color.

You can use Rob Bovey's XY Chart Labeler to put a secondary label on those
points. It's found at www.appspro.com

http://www.peltiertech.com/Excel/Cha...mmySeries.html

May help you as well.


"SM" wrote in message
...
Thanks for the suggestion.

I need to have 2 values ONLY shown on the x-axis, the value of the mean
and
the z-value (or equivalent). Is this possible?

"Barb Reinhardt" wrote:

If you know what you want for your X and Y coordinates, you can use this
tutorial

http://www.peltiertech.com/Excel/Cha...AreaChart.html

"SM" wrote in message
...
I know a rough bell-shaped curve can be drawn in Excel using random
numbers.
Can normal distribution curves showing an area under the curve, i.e
z-test
or
t-test area, be drawn in Excel? If yes, how?

Thanks