If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How do I Generate Multiple Graphs for Different Series of Data
What I'm trying to do is create multiple Graphs, one for each location.
Specifically the data looks like this: Store Product Sales 1 Apples 100 1 Oranges 120 1 Bananas 200 2 Apples 200 2 Oranges 320 2 Bananas 500 I want to create a Pie Chart for Each Store, showing the Percentage of Sales by Product For Each Location. When I created a Pivot Table, I got too many labels, and it would also have required me to Manually Select which Store Location I wanted to print on. Is there any way to do this from within Excel? (Note: I am using Excel 2003, and although I've used the product extensively, am now just starting to delve into the Murky Waters of Charting.) Thanks in advance for any assistance. |
#2
|
|||
|
|||
How do I Generate Multiple Graphs for Different Series of Data
Hi,
Excel will not automatically create multiple charts from your data source. To do that you will need to create VBA code to produce a chart at the change of Store ID. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MC_FRx_99" wrote in message ... What I'm trying to do is create multiple Graphs, one for each location. Specifically the data looks like this: Store Product Sales 1 Apples 100 1 Oranges 120 1 Bananas 200 2 Apples 200 2 Oranges 320 2 Bananas 500 I want to create a Pie Chart for Each Store, showing the Percentage of Sales by Product For Each Location. When I created a Pivot Table, I got too many labels, and it would also have required me to Manually Select which Store Location I wanted to print on. Is there any way to do this from within Excel? (Note: I am using Excel 2003, and although I've used the product extensively, am now just starting to delve into the Murky Waters of Charting.) Thanks in advance for any assistance. |
#3
|
|||
|
|||
How do I Generate Multiple Graphs for Different Series of Data
Hi Andy,
Thanks for your considered response. If this isn't already a part of Charting & Graphing, then in my opinion it should be! Hopefully someone either who works with Microsoft or has connections there should be able to tell them about this desired feature. It's already in Crystal Reports for 10 years or more! "Andy Pope" wrote: Hi, Excel will not automatically create multiple charts from your data source. To do that you will need to create VBA code to produce a chart at the change of Store ID. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "MC_FRx_99" wrote in message ... What I'm trying to do is create multiple Graphs, one for each location. Specifically the data looks like this: Store Product Sales 1 Apples 100 1 Oranges 120 1 Bananas 200 2 Apples 200 2 Oranges 320 2 Bananas 500 I want to create a Pie Chart for Each Store, showing the Percentage of Sales by Product For Each Location. When I created a Pivot Table, I got too many labels, and it would also have required me to Manually Select which Store Location I wanted to print on. Is there any way to do this from within Excel? (Note: I am using Excel 2003, and although I've used the product extensively, am now just starting to delve into the Murky Waters of Charting.) Thanks in advance for any assistance. |
Thread Tools | |
Display Modes | |
|
|