Sum & report contents of table containing text values?
 

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
--
Neil

Sum & report contents of table containing text values?
 

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

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.


Neil wrote:
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
Contextures
http://www.contextures.com/tiptech.html