In this case I think it might be easier just to create a histogram the old school way with custom bins and countifs() function to count datapoints that fall between each bin. Then create a column chart of the count values.
I am not sure exactly what you'd like to do- see this video where I add a normal curve to a histogram, and see if those techniques help you. If not, let me know what changes you'd like!
Maybe you can try insert column or bar chart instead of using histogram. When I insert the histogram, I really can't paste special after copy the figures. But it works when I used the column as the graph.
@@teotzeyongc229 It is sad that Microsoft continues to randomly change functionality and menus. I'll try to revisit this soon and see if there is a better method now.
It works! However I'm starting to think that there isn't a histogram chart in excel by default for a reason. This method of displaying the data serves no purpose compared to a bar graph and only if you're in a stupid statistics program will you ever need this.
