How do I create a histogram in Microsoft Excel?

  • Thread starter Thread starter manjuvenamma
  • Start date Start date
  • Tags Tags
    Excel Histogram
Join the discussion
Registration is free. Ask a follow-up in this thread, or start your own.
3 replies · 3K views
manjuvenamma
Messages
102
Reaction score
0
Is it possible to draw histograms in Microsoft Excel? I see all charts of icons in the Excel tool bar but no histogram.
 
Physics news on Phys.org
You can use Insert -> Columns for histograms. Together with the matrix function {=frequency()} (with contr, alt, enter) you can work out some decent statistics.
 
"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.