View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Mike Middleton Mike Middleton is offline
external usenet poster
 
Posts: 762
Default how to draw Gaussian distribution graph

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?