Chart question

  • Thread starter Thread starter Matthew
  • Start date Start date
M

Matthew

I have a list of text like that following:



SearchEngines

Ask Jeeves

Ask Jeeves

Ask Jeeves

Ask Jeeves

Ask Jeeves

Excite

Excite

Excite

Excite

Google

Google



I want to make a column chart titled "SearchEngines" showing that Ask Jeeves
appears 5 times, Excite appears 4 times, and Google appears 2 times.



How do I accomplish this?



Matthew
 
You can create a pivot table from the list, to get a quick summary of
the data:

1. Select a cell in the list
2. Choose Data>PivotTable Report
3. Click Next, select the cells with data, click Next
4. Click Layout
5. Drag the SearchEngines button to the row area
6. Drag another copy of the SearchEngines button to the Data area,
where it will become Count of SearchEngines
7. Click Next, choose a location for the Pivot Table, click Finish
8. Then, create a PivotChart from the PivotTable.
 
Back
Top