Aim: Count occurrences of words in a column and create a pie chart from it.
The column that you'd like to chart should have a title in its first cell.
- Select the column.
- Data -> DataPilot -> Start.
- Use current selection.
- Window will pop up to define the data fields.
- There will be a button at the top with the name of the first cell in the column we selected earlier.
- Drag it into the 'Row fields'.
- Drag it into the 'Data fields', click the 'Options' button and select count.
- Click the more button and set the results to go into a new sheet.
- You now have a data table in the new sheet which counts the words in the source selection.
- When the data in the source selection changes, right click the title cell of the data table and refresh.
- Select the part of the data table that you'd like to count and click the 'Chart wizard' button to create a chart.
- Or, select the data table's title cell and click the 'Chart wizard' button to create a chart. This will include the total in the chart.