Chart question

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
 
D

Debra Dalgleish

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