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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Can a pie of pie chart use animation/transitions? 1
Pie Chart Resize 2
Pie charts 1
Extra Slice in Pie in Pie chart 4
Pie Chart 4
Pie Chart - Columns 1
pie chart areas reflect magnitude 5
Creating Pie Chart 3

Back
Top