Sum & report contents of table containing text values?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Neil - 30 Sep 2006 10:45 GMT

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

Signature

Neil

Reply to this Message

Debra Dalgleish - 30 Sep 2006 16:30 GMT

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.

> 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

Signature

Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

Reply to this Message