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.

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.

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.