Excel Histogram: How to put limits in the right place!

Previously we say how to make a frequency distribution and histogram in Excel. The easy way is to put the bin ranges in the center of each bar. A viewer asks: Can you put the limits at each end of the bar? Yes: but it is difficult. Let me show you how, the easiest way.

[@xinpan7872]

It is very complicated. But it does work!!! I can never thank you enough!!!! Really do appreciate it!

[@misomoon]

woah, thank you! i can't believe this actually worked!

[@TheEngineeringToolboxChannel]

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.

[@frankhemd7198]

holy sh... u just helped me.
ive been googling my a... off since 1.5 days and u just saved me
dude thank you from the bottom of my heart

[@darrengale848]

Thank you really helpful.

Hi. You save my life.i have been looking for this. Thank you so much.
love from portugal.

[@Josephlee1995]

Well thought and devised.

[@dianazenelaj6985]

Thank you so much!

[@emmasun8885]

Thank you!!

[@athenawu4521]

It works!!! Thank you very much

[@shakyasinha4059]

It works. Difficult to remember those steps. I think using textbox, manually type x axis value is much easier. Is there no other such option ?

[@ChristopherAndrewQuarrie]

I went with textboxes. Not very elegant but it worked

[@tanyagwillim5801]

Thank you!

[@renjunisscreaming1329]

when I click 'on tick marks' it just moves the tick mark to the center of every bars 😭

[@kingofhearts15p]

Cannot "Paste Special"

[@teotzeyongc229]

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.

[@BurkeyAcademy]

@@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.

[@alisha9738]

Same!

[@emmanueljohnandrewappianin6212]

It works well. However, I can't get the X-Axis label to appear at the bottom. It keeps appearing at the top. Where the original values are now white.

[@joegildberg250]

thank youu

[@rajatayyip7694]

Please guide me how to adjust bar width, proportional to class width/height

[@pohchinghong4625]

my excel 2016 dun have the secondary horizontal option, may I know how can I activate it??

[@brunovieirasilva1981]

Thanks

[@lourdsarballon5620]

hi alman

[@shugsz301]

hi lourd

[@lourdsarballon5620]

yawaa salamat kaayo buanga ka

[@wm6739]

Thank you, I've been looking for the answer to this for a long time, but how do you do this for 2 or more data sets in the same histogram?

[@BurkeyAcademy]

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!

[@genesisyt4763]

did u figure it out? I need help w that right now hahah for my econometrics assignment

[@wm6739]

@@genesisyt4763 I did but that was 3 years ago and I've forgotten how, sorry

[@syazwani3285]

it doesnt work for me :( when i click paste special nothing happen:(((((((((((((

[@BurkeyAcademy]

Well, blame old Micro$oft... they are always messing things up. I'll try to take another look at this and see what I can do.

[@alisha9738]

Doesn't work for me either. No paste special available when I click on the graph

[@syazwani3285]

@@alisha9738 same.! we have the same problem sis

[@michaelraum3393]

No paste special option

[@Saruman1000]

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.

[@crazedvidmaker]

10 minutes? Seriously?