How do I Generate Multiple Graphs for Different Series of Data

  • Thread starter Thread starter MC_FRx_99
  • Start date Start date
M

MC_FRx_99

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
 
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!
 
Back
Top