In the subject you mention a vertical ND curve but in the body you=20
mention horizontally. So, it is not clear what you want to do.
In any case, you might want to check
http://www.tushar-
mehta.com/excel/tips/index.html specifically the link for 'Invert and=20
rotate charts'
To draw straight lines that match up with pre-determined values see=20
http://www.tushar-mehta.com/excel/ch...nes/index.html =20
Also, Jon Peltier has an alternative approach on his site.
--=20
Regards,
Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article ,=20
says...
I would like to plot a normal distribution curve horizontally (on the Y a=
xis)=20
in a chart with vertical data histogram plots (up and down) and horizonta=
l=20
line plots (+/- 1 SD) =E2=A4=3D3F all currently using the Y axis. I have=
the=20
histogram/SD portion built. Is there a way to use a secondary axis on th=
e=20
left side of the chart for the nd curve, yet have the nd curve appear on =
the=20
right side of the chart? Actually, it may not make a difference just whi=
ch=20
axis, Y or secondary, the plots are attached to so long as the plots can =
be=20
placed on the chart in an orderly fashion to display three issues: histog=
ram=20
data, lines for +/- 1 SD, nd curve - the SD lines must be logical with th=
e nd=20
curve. The next question: how would I shade the area of +/- 1 SD?
=20
Thanks,
Phil
=20