PIE CHART

Pls Help me..

I have a set of data as follows:-

GRED/SUBJECT MATH HISTORY BIOLOGY PHYSIC
A 1 2 3 4
B 1 2 3 6
C 2 4 6 8
D 3 6 9 12
E 1 3 5 7

Is there any possiblity to build the abovesaid data in one
pie chart?

How do you envision showing the data set in one pie chart?

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

In article ,
says...
Pls Help me..

I have a set of data as follows:-

GRED/SUBJECT MATH HISTORY BIOLOGY PHYSIC
A 1 2 3 4
B 1 2 3 6
C 2 4 6 8
D 3 6 9 12
E 1 3 5 7

Is there any possiblity to build the abovesaid data in one
pie chart?

I want to do the same thing, and have a vague recollection of a previous version of Excel that would accept multiple pie data series, and would show one pie for each series. You could either make all the pies the same size, or make them different sizes, proportional to the sums of the series. Does anybody else recall this feature? I can't make my current version do this.

Howard -

This feature doesn't sound familiar. You can pretty easily change the
source data range for a pie chart, so you could make one chart, then
copy it as many times as needed and change the data accordingly. This
would give you multiple charts of the same size (or random size if the
labels cause the charts to be redrawn).

It wouldn't be too hard to write VBA that would let you select a larger
range and spit out multiple identically or proportionally sized charts.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Howard wrote:

I want to do the same thing, and have a vague recollection of a previous version of Excel that would accept multiple pie data series, and would show one pie for each series. You could either make all the pies the same size, or make them different sizes, proportional to the sums of the series. Does anybody else recall this feature? I can't make my current version do this.

I do remember that feature. Several data series could be added into the pie chart. The finshed chart then displayed separate pie charts for each series. I cannot set this up anymore.

Brad -

Excel doesn't (and I don't think ever did) let you place multiple pies
within a single chart, aside from the special Pie-of-Pie chart. You can
get something similar, though. If the chart you want is embedded in a
worksheet, just make several single pie pie charts, and arrange them
near each other. If you want a chart sheet with multiple pies, make a
blank chart sheet first, by selecting a blank cell which is not touching
any non blank cells, and pressing the F11 key. Make your pie charts, and
on step 4 of the wizard for each (or by right clicking on the finished
hart and choosing Location) choose the As Object In option, and select
the name of the chart sheet. When finished, arrange the pies as you like
in the chart sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Brad Sours wrote:
I do remember that feature. Several data series could be added into the pie chart. The finshed chart then displayed separate pie charts for each series. I cannot set this up anymore.