Plot a line on a graph which already has a bell curve on it

[Philip041]

I know this question has been asked on many websites, but I can't seem to be able to do it with the answers I found.

I managed to plot my normal distribution. I chose to do it as a line graph. I have the standard deviations but I have tried plotting lines but can't get them on there. I want to show the standard deviation with a line going from the x axis to the line I've plotted. Each time I do it I get a line either hugging the y axis or an x axis which goes from 'point A' to 'point A', so even though it should be vertical excel has spread point A so much that my vertical line looks like the tower of Pisa.

Any help much appreciated.

 

[pgc01]

Hi Philip

This is a numerical XY function, it should be a scatter chart, not a line chart.

Change its type, and to add the line add a new series with 2 points, the end points of the line segment.

 

[Philip041]

Hi,

Thanks. I know it should be scatter but my boss wants it as a line graph...

Will I be able to change the first series back to a line?