Text list to graph

M

Mark Flynn

Hi:
I have a column listing car makes in random order with duplicates:
Mazda
Honda
Honda
Toyota
Chevy
Mazda... etc.
QUESTION: How can I create a chart from this list?
I've tried sorting, then sub-totaling. Am I on the right track?
Thanks, Mark Flynn
 
D

Debra Dalgleish

You can summarize the data with a Pivot Table, and create a chart from that.

Add a heading to the list, e.g. Cars
Select a cell in the table.
Choose Data>PivotTable and PivotChart Report
Select PivotChart report (with PivotTable report), click Next
Select the Data range, click Next
Click Layout
Drag the Cars button to the Row area
Drag Cars again to the data area, where it will become Count of Cars
Click OK, click Finish

A column chart will be created, and you can modify it.
 
D

Don Guillett

Pivot table or just create another list somewhere using a COUNTIF or
SUMPRODUCT formula to get
Mazda 100
Honda 50
 
M

Mark Flynn

Debra and Don, thank you for your help.
I appreciate your time and expertise
Mark Flynn
 
C

CLR

Hi Mark............

You can alphabetize the column, then do Data > Subtotals > Count > CarColumn

It will give you a total count of how many times each brand is in the
list...........

Vaya con Dios,
Chuck, CABGx3
 
Top