Forum Discussion
HISTOGRAM CHARTING non numerical data
Hi team,
I am struggling with the creation of an histogram of non numerical data.
| ID | gender | etnicity |
| 1 | m | A |
| 2 | f | B |
| 3 | f | B |
| 4 | f | C |
| 5 | f | C |
| 6 | m | B |
| 7 | m | A |
| 8 | m | B |
i would like to find a easy way to display the data on histograms, for example
a histogram for the gender, a histogram for the etnicity etc..
without creating new data sheets, since the variables are a lot.
is it possible or should i necessairly use other frequency formulas on the file (COUNTIFS or similar)?
thank you so much!
I'd create a pivot table based on the data, then a chart based on the pivot table.
You can easily slice and dice the data in the pivot table, and the pivot chart will be updated automatically.
