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.