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. |
Thread Tools | |
Display Modes | |
|
|