ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How to add a normal distribution to a histogram (https://www.excelbanter.com/excel-discussion-misc-queries/99299-how-add-normal-distribution-histogram.html)

AdamCPTD

How to add a normal distribution to a histogram
 
Trying to add a Gaussian (Normal Distribution) curve to a histogram using a
scatter chart over top of a bar chart.
The problem I have is that the scale of the histogram doesn't match the
scale of the Normal Curve. I could set them equal manually, but that is
impractical because the scale of the histogram is always changing as new data
points are added.
Can I plot the Normal Distribution on the same X axis as the histogram, or
can I have the scales of the two series match somehow?

Thanks,

Adam


All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com