Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Histogram in EXCEL

  1. Jun 29, 2012 #1
    Is it possible to draw histograms in Microsoft Excel? I see all charts of icons in the Excel tool bar but no histogram.
  2. jcsd
  3. Jun 29, 2012 #2


    User Avatar
    Gold Member

    click on "other charts"
  4. Jun 29, 2012 #3
    You can use Insert -> Columns for histograms. Together with the matrix function {=frequency()} (with contr, alt, enter) you can work out some decent statistics.
  5. Jul 1, 2012 #4
    "other charts" or "columns' is of no help. But I read on the net, histogram is not available with Excel as it is, you have to install some add-in.
    Thanks for trying to help.
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook