words as data for formula or chart

  • Thread starter Thread starter Andy_CYXU
  • Start date Start date
A

Andy_CYXU

How can i crate a chart that would use words as data so
basically the charts formula would count words in column
to output value for example:

I have a column where there are words: YES, NO, MAYBE
etc... (all in one column)

and I like on the chart to show that there are so many
words YES, so many words NO, so many words MAYBE etc...
in that column..
It could show a bar besically the longest means there is
the most of these words ets...
Is it possible?

Thanks
 
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.
 
Back
Top