Khoshravan -
Excel has features for creating the histogram and for plotting the curve
using data from the NORMDIST worksheet function. But Excel does not have an
automatic feature for combining the histogram (Column chart type) and normal
curve (XY Scatter chart type). It can be difficult to line up the horizontal
axes (Column category and XY numerical) and to scale the vertical axes.
See the Histogram page at
www.treeplan.com for an example that uses the two
chart types.
See
http://www.mikemiddleton.com/Histogr...ormalCurve.xls for an example
that uses proper scaling.
- Mike
http://www.MikeMiddleton.com
"Khoshravan" wrote in message
...
After drawing a histogram through data analysis, I want to draw a Gaussian
distribution graph (standard or reverse bell-shape graph) relevant to my
frequency data. Is there any built-in function to carry out this drawing?