Draw Histogram in Excel: Is it Possible?

[manjuvenamma]

Is it possible to draw histograms in Microsoft Excel? I see all charts of icons in the Excel tool bar but no histogram.

 

[phinds]

click on "other charts"

 

[Andre]

You can use Insert -> Columns for histograms. Together with the matrix function {=frequency()} (with contr, alt, enter) you can work out some decent statistics.

 

[manjuvenamma]

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

 

[alphy]

Yes, it is possible to draw histograms in Microsoft Excel. To do so, you can follow these steps:

1. Select the data range for which you want to create a histogram.

2. Go to the Insert tab and click on the "Recommended Charts" option.

3. In the "All Charts" tab, select the "Histogram" option.

4. Click on the "OK" button and a histogram chart will be inserted into your Excel sheet.

Alternatively, you can also create a histogram by using the "Data Analysis" tool in Excel. This can be accessed by going to the Data tab and clicking on the "Data Analysis" button.

In conclusion, Microsoft Excel does have the capability to create histograms, and it can be done using either the "Recommended Charts" or "Data Analysis" tools. I hope this helps!