Forumula for Excel Bell Curve and Histogram

H everyone,

I'm trying to draw a histogram and a bell curve with some data. I have the categories and frequency of each category, however I still lack a formula that takes into account the mean and standard deviation for the chart.
Please refer to the enclosed attachment.
Can someone please help and solve this problem for me please? Thank you very much.

Best Regards

Bernard

Hi, is anyone able to help on this problem please? Would appreciate it very much. Thanks.

Yes, I did, but I'm not able to get the bell curve result using that formula, as I'm using the secondary axis for the curve. What I need is a formula, so that the secondary axis can show the bell curve.

The problem is that what I have is a consolidated data, e.g. 0-30 is 98 frequency, 31-40 is 54 frequency, etc, so if I were to use NormDist function, I will need to manually break them down into raw data, which is extremely tedious.