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.

[@user-wy2ep4gh2u]

What do you mean when you say that you create a bin for categories? It is not clear from the video where to click.

[@majidnabavi4465]

Creating bin for categorical data is what I did around 8:30 timeline. Each category title is its own bin, then the count comes next to it.

[@user-wy2ep4gh2u]

@@majidnabavi4465 Thank you! But how do you create this list with categories for Bing range (Married, Single, Divorced, Widowed)? I see them when I apply a filter but what should I do next? Just rewrite them?

[@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%.

[@majidnabavi4465]

you need to type them.