How do I Generate Multiple Graphs for Different Series of Data


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

Advertisements

A

Andy Pope

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
 
Ad

Advertisements

M

MC_FRx_99

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top