HISTOGRAM CHARTING non numerical data

[EdoardoMiotto]

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!

[#2]

@EdoardoMiotto 

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.