how to make a bell curve in excel step by step guide a bell curve also known as normal distribution curve is a way to plot and analyze data that looks like a bell curve in the bell curve the highest point is the one that has the highest probability xl how to create a bell curve chart support microsoft com the chart will have two curved series and a flat series along the x axis double click the second series it should be labeled bin in the legend in the format data series dialog box click the ax histogram with normal distribution overlay in excel this tutorial will walk you through plotting a histogram with excel and then overlaying normal distribution bell curve and showing average and standard deviation lines to produce my random normal sam excel histograms how to add a normal curve here we add a normal distribution curve to an existing histogram so you can compare your data to a normal distribution with the same mean and standard deviation as usual it is a pain to do this bell curve and histogram creation detailed instructions on creating the bell curve and histogram formulas and creating combination charts step by step including many excel shortcuts step b histogram with normal curve overlay peltier tech blog in chart 10 ive changed the series type of the histogram data to an area chart and moved it to the secondary axis it looks weird but its too early to panic it looks weird but i xlf histogram with normal curve overlay excelatfinance com 2 4 the histogram and normal curve charts looking at figure 8 the three area marked 1 2 and 3 are the series for the charts in figures 10 11 and 12 first item 2 the relfreq and 3 the relnor how to create a bell curve chart template in excel save the bell curve chart as a chart template a in excel 2013 right click the bell curve chart and select the save as template from the right clicking menu b in excel 2007 and 2010 click the be historgrams and overlayed normal curves in excel blogger however in 2007 excel provides more automated function to generate frequency table and histograms b in excel 2007 the function histogram can be used to generate bin and empirical frequency and gene