List all selections from drop down

[Dax Arroway]

I have a spreadsheet with drop down menues. One menu, for example, is
ethnicity which lists, Caucasian, Black, Hispanic, etc. There are no
Hispanic people thus far. I've got a pivot table which grabs the data from
the Ethnicity feild and creates a graph chart for it but since there are no
Hispanics in the list, it is not listed. How do I get it to list all the
selections even if there are no entries for it?

Thanks in advance.

 

[Dan]

Add a record for a the missing ethnicity and then refresh your pivot
table.

Right click on the ethnicity column and select Field Settings, then
check "Show items with no data", and OK it.

You should now be able to remove the hispanic, or missing ethnicity
record from your data table and the field will stay in the pivot
listing.

KInd regards,

Dan