how do I draw a historgram?

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?
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I get a histogram using EXCEL 1
how to draw Gaussian distribution graph 3
Creating Histograms using Excel 1
How do I draw an accurate venn diagram? 3
How do I draw chemical structures in Excel spreed sheet? 1
Histogram, And "Normal" Curve For ? 1
How do I draw a candlestick using excel 1
how to draw a pictograph? 1

Top