HISTOGRAM CHARTING non numerical data

New Contributor

Hi team,

 

I am struggling with the creation of an histogram of non numerical data.

 

IDgenderetnicity
1mA
2fB
3fB
4fC
5fC
6mB
7mA
8mB

 

 

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!

 

1 Reply

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