Does anyone know how to create a special chart that would create a graph of two fields based on number of counts of one of those fields (zip code)?
I need to create a chart that would graph sales based on the zip code.
This is the way the excel sheet is setup.
Date service amount zip code
1 100 60068
2 125 60630
3 205 60616
4 235 60068
4 200 60630
Date is the date of service and there can be multiple service lines for the same date.
The totals in this chart would be based on zip codes and the graph would also be based on zip codes.
The sheet is also setup to calculate totals for the month and than there is another sheet that adds the count for the year.
The graph would most likely need to add fields for the month and than for the year.
Zip code
60068 100+235=335
60616 205
60630 125+200=325
What I need is a graph that would add the service amount and graph them based on the zip codes so I would know how much business I get from each zip code.
Any ideas
Thanks for all your help
Robert
I need to create a chart that would graph sales based on the zip code.
This is the way the excel sheet is setup.
Date service amount zip code
1 100 60068
2 125 60630
3 205 60616
4 235 60068
4 200 60630
Date is the date of service and there can be multiple service lines for the same date.
The totals in this chart would be based on zip codes and the graph would also be based on zip codes.
The sheet is also setup to calculate totals for the month and than there is another sheet that adds the count for the year.
The graph would most likely need to add fields for the month and than for the year.
Zip code
60068 100+235=335
60616 205
60630 125+200=325
What I need is a graph that would add the service amount and graph them based on the zip codes so I would know how much business I get from each zip code.
Any ideas
Thanks for all your help
Robert
