| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Formula to create pie chart
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. |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Formula to create pie chart
On Fri, 21 Dec 2007, in microsoft.public.excel.charting,
Tammy said: 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. Use a pivot table to count the zip codes: ZIP_CODE Count Of ZIP_CODE -- Del Cotter NB Personal replies to this post will send email to , which goes to a spam folder-- please send your email to del3 instead. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a formula for a Chart of Account list? | Excel Worksheet Functions | |||
| create line chart with two axises in Pivot Chart | Charts and Charting in Excel | |||
| Chart data file lost - need to re-create from chart? | Charts and Charting in Excel | |||
| Create a combo chart with two of the same chart types | Charts and Charting in Excel | |||
| create a chart with a formula | Charts and Charting in Excel | |||
Linear Mode
