PIE CHART

  • Thread starter Thread starter GUESSWHO
  • Start date Start date
G

GUESSWHO

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
 
You can show only one series of data in a pie chart, for example the
distribution of letter grades in Math class. You'd need four pies to
show your data, but I think you'd be better with a stacked 100% column
chart. Use this data (remove the "GRED/SUBJECT" in the top left cell,
and reverse the order of the grades):

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

Run the chart wizard, and make a stacked 100% column chart (top left
choice on the right after clicking the column chart button in step 1 of
the wizard). In step two of the wizard, choose to plot series by rows.
This shows the percentages of each grade in each class, in a way which
is easier to compare than side by side pie charts.

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