Excel Histogram for numeric and categorical data

[@rgreen5358]

Excellent video to get past Excel's default limitations

[@flytocities7192]

Thanks. For categorical data, see 6:14.

[@hendygeek]

That's not a Histogram, that's creating a count data first then making a bar chart.
Why can't the histogram chart used directly? Is it an Excel bug?

[@majidnabavi4465]

Histogram is a column chart of frequency. I used the Excel tool for numeric data but The count and column chart is used for categorical data. Excel histogram tool works for numbers only, not for strings.

[@hendygeek]

Majid Nabavi so it is an Excel bug :(

[@karthikamuthiah311]

@@majidnabavi4465 You can select bar chart first, then click on the bars to go to formatting, and make the gap width 0%.