Formula to create pie chart

  • Thread starter Thread starter Tammy
  • Start date Start date
T

Tammy

I have an excel spreadsheet with addresses sorted by zip codes. I am trying
to creat a pie chart indicating what % of our referrals come from what zip
code. How do I get the repetitive zip codes to total? Right now every line is
creating a separate piece of the pie.
 
I have an excel spreadsheet with addresses sorted by zip codes. I am trying
to creat a pie chart indicating what % of our referrals come from what zip
code. How do I get the repetitive zip codes to total? Right now every line is
creating a separate piece of the pie.
Click to expand...

Use a pivot table to count the zip codes:

ZIP_CODE Count Of ZIP_CODE
 
Back
Top