I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?

Tushar Mehta has a tutorial on this topic:

http://tushar-mehta.com/excel/charts...tion/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:

I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?

Thanks for the info.

One more question: I created the bell graph, now how do I plot points on
the curve of the graph? I have 15 points that I need to show along the curve.

thanks,
Chris


"Jon Peltier" wrote:

Tushar Mehta has a tutorial on this topic:

http://tushar-mehta.com/excel/charts...tion/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:

I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?

Put the X and Y values of the 15 points into two columns, copy this
data, and use Paste Special (Edit menu) to add the data to the chart as
a new series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:

Thanks for the info.

One more question: I created the bell graph, now how do I plot points on
the curve of the graph? I have 15 points that I need to show along the curve.

thanks,
Chris


"Jon Peltier" wrote:


Tushar Mehta has a tutorial on this topic:

http://tushar-mehta.com/excel/charts...tion/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:


I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?

Ok, I wasn't clear on what I need to do, or maybe I don't understand. I have
15 points from a set of data that could represent X axis points based on how
I created the bell curve. I do not have any y axis data. I used the
"enumerating a set of points in a worksheet" from the tushar-mehta tutorial
way of creating my bell curve. I want to plot the 15 points that I have on
the bell curve that I created. I made the bell curve using:
mean = 68.44
stdev = 6.52
step value = 1
stop value = 15

Now my set of data that I want to plot on this graph a
67.81
68.89
72.56
61.62
66.81
66.13
54.42
58.18
57.35
63.29
68.98
69.74
67.35
80.74
62.16
I want to show these points along the curve, but I do not know what values
to use for a y axis point for each one.

thanks for the help so far,
Chris



"Jon Peltier" wrote:

Put the X and Y values of the 15 points into two columns, copy this
data, and use Paste Special (Edit menu) to add the data to the chart as
a new series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:

Thanks for the info.

One more question: I created the bell graph, now how do I plot points on
the curve of the graph? I have 15 points that I need to show along the curve.

thanks,
Chris


"Jon Peltier" wrote:


Tushar Mehta has a tutorial on this topic:

http://tushar-mehta.com/excel/charts...tion/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:


I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?

After following Tushar's example step-by-step, put your desired X values
into E3:E17. Put this formula into F3, and fill it down:

=NORMDIST(E3,$F$1,$H$1,FALSE)

This is the same formula that you used already in column C to provide
the distribution values for the X data in column B. Plot the values in E
and F on the chart with those for B and C. Use markers without
connecting lines (or else it looks like a tangled cat's cradle).

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:

Ok, I wasn't clear on what I need to do, or maybe I don't understand. I have
15 points from a set of data that could represent X axis points based on how
I created the bell curve. I do not have any y axis data. I used the
"enumerating a set of points in a worksheet" from the tushar-mehta tutorial
way of creating my bell curve. I want to plot the 15 points that I have on
the bell curve that I created. I made the bell curve using:
mean = 68.44
stdev = 6.52
step value = 1
stop value = 15

Now my set of data that I want to plot on this graph a
67.81
68.89
72.56
61.62
66.81
66.13
54.42
58.18
57.35
63.29
68.98
69.74
67.35
80.74
62.16
I want to show these points along the curve, but I do not know what values
to use for a y axis point for each one.

thanks for the help so far,
Chris



"Jon Peltier" wrote:


Put the X and Y values of the 15 points into two columns, copy this
data, and use Paste Special (Edit menu) to add the data to the chart as
a new series.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:


Thanks for the info.

One more question: I created the bell graph, now how do I plot points on
the curve of the graph? I have 15 points that I need to show along the curve.

thanks,
Chris


"Jon Peltier" wrote:



Tushar Mehta has a tutorial on this topic:

http://tushar-mehta.com/excel/charts...tion/index.htm

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______


Lucien wrote:



I have 15 data points with a predetermined mean. How do I create a bell
graph to show the standard deviation lines and all of the data points along
the X axis?