Display Mean and Confidence Intervals on Bell Curve

[cp41]

Hello all,

I've managed to figure out how to normalize my data and create several bell curves. However, these charts do not display the mean, std deviation, or confidence intervals. Does anyone know of a way to add these into my charts?

Thanks!

[shg]

Just add a series for each:

	A	B
1	x	y
2	mean-sd	0
3	mean-sd	max y
4
5	mean	0
6	mean	max y
7
8	mean+sd	0
9	mean+sd	max y

[cp41]

i did this..but i can't get them to be plotted on the same axis. any suggestions?

[shg]

Yes -- post the workbook.

[cp41]

NormalCurve.xlsm the attachment should briefly explain what i am seeing.

Thanks

[shg]

I don't see that you even attempted to add the series.

[cp41]

Right click on either of the middle plot areas and select data. i added series in that way..is that not what you meant?

[shg]

Maybe as attached.