Text list to graph

  • Thread starter Thread starter Mark Flynn
  • Start date Start date
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
 
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.
 
Pivot table or just create another list somewhere using a COUNTIF or
SUMPRODUCT formula to get
Mazda 100
Honda 50
 
Debra and Don, thank you for your help.
I appreciate your time and expertise
Mark Flynn
 
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
 
Back
Top