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.
|