You can create a pivot table from the list, to get a quick summary of
the data:
Add a heading to the top of the list (e.g. Response)
Select a cell in the list
Choose Data>PivotTable and PivotChart Report
Click Next, select the cells with data, click Next
Click Layout
Drag the Response button to the row area
Drag another copy of the Response button to the Data area,
where it will become Count of Response
Click Next, choose a location for the Pivot Table, click Finish
Then, click the Chart Wizard button, to create a PivotChart
from the PivotTable.
> How can i crate a chart that would use words as data so
> basically the charts formula would count words in column
[quoted text clipped - 9 lines]
> the most of these words ets...
> Is it possible?

Signature
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Andy_CYXU - 04 Jan 2004 04:22 GMT
Thank You !
It worked !
Andy