how do I draw a historgram?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

there is no predefined option to draw histograms or is there? I did not find
any. can anyone tell me how to draw a histogram using excel?
 
Use Tools | Data Analysis | Histogram
If you do not see Data Analysis then you need to but the Office/Excel CD in
the drive and use Add/Delete Programs to install this feature.

OR
You could use the FREQUENCY function to make a data table then make a column
chart. You can format the data series in a column chart so that the columns
have no gaps between them

I searched Google with "Excel histogram" and found a number of sites. This
one seems helpful
http://www.treeplan.com/BetterHistogram_20041117_1555.htm

Please return if you need more details
best wishes
 
Back
Top