A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How do I Generate Multiple Graphs for Different Series of Data



 
 
Thread Tools Display Modes
  #1  
Old September 15th, 2009, 10:37 PM posted to microsoft.public.excel.charting
MC_FRx_99
external usenet poster
 
Posts: 6
Default 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.
  #2  
Old September 16th, 2009, 08:59 AM posted to microsoft.public.excel.charting
Andy Pope
external usenet poster
 
Posts: 2,088
Default How do I Generate Multiple Graphs for Different Series of Data

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.


  #3  
Old September 16th, 2009, 09:19 PM posted to microsoft.public.excel.charting
MC_FRx_99
external usenet poster
 
Posts: 6
Default How do I Generate Multiple Graphs for Different Series of Data

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.



 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 03:21 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.