Sum & report contents of table containing text values?

[Neil]

Can excel summate and report in charts text information recorded in a single
table. EG Columns entitled Hair, Eyes, Height with values blue brown green
auburn blond dark tall short medium. etc

 

[Debra Dalgleish]

You could use a pivot table to summarize the data, and create a chart
from that. There are instructions and links here:

http://www.contextures.com/xlPivot01.html

For example, put Hair in the row area and Eyes in the column area.
Put Height in the data area, as Count of height.