Thread: Pie Chart with 3 data series?

Hi,

I have a column of 8 labels with 2 columns of data next to it (two numbers
for each label). (one of the data columns contains smaller numbers that
represent a percentage of the other corresponding number in the other column)
I can build a pie chart based on the larger data series so I have 8 slices,
but can I also have the small data series displayed as small line arcs within
each pie wedge to represent the proportion of the smaller number in the
column to the larger number in the other column? The arcs around the inner
center area of the pie would vary, since the percentages are different, so it
would not be a concentric ring within the pie, but uneven small arcs within
each slice, the distance from the absolute center of the pie to each arc
varying for each slice since the percentage of the smaller number to the
larger number varies.

I couldnt find any chart types like this, so I was wondering if I need a
program like Visio or could Excel do it?

Thank you very much

Craig

Does it have to be a Pie Chart. How about a non-stacked line chart in which
you plot the data series, removing the lines at the end to show only the data
points.


"Craig" wrote:

> Hi,
>
> I have a column of 8 labels with 2 columns of data next to it (two numbers
> for each label). (one of the data columns contains smaller numbers that
> represent a percentage of the other corresponding number in the other column)
> I can build a pie chart based on the larger data series so I have 8 slices,
> but can I also have the small data series displayed as small line arcs within
> each pie wedge to represent the proportion of the smaller number in the
> column to the larger number in the other column? The arcs around the inner
> center area of the pie would vary, since the percentages are different, so it
> would not be a concentric ring within the pie, but uneven small arcs within
> each slice, the distance from the absolute center of the pie to each arc
> varying for each slice since the percentage of the smaller number to the
> larger number varies.
>
> I couldnt find any chart types like this, so I was wondering if I need a
> program like Visio or could Excel do it?
>
> Thank you very much
>
> Craig

Hi,

You might find this technique of interest.
http://www.andypope.info/charts/pieradius.htm

Cheers
Andy
Craig wrote:
> Hi,
>
> I have a column of 8 labels with 2 columns of data next to it (two numbers
> for each label). (one of the data columns contains smaller numbers that
> represent a percentage of the other corresponding number in the other column)
> I can build a pie chart based on the larger data series so I have 8 slices,
> but can I also have the small data series displayed as small line arcs within
> each pie wedge to represent the proportion of the smaller number in the
> column to the larger number in the other column? The arcs around the inner
> center area of the pie would vary, since the percentages are different, so it
> would not be a concentric ring within the pie, but uneven small arcs within
> each slice, the distance from the absolute center of the pie to each arc
> varying for each slice since the percentage of the smaller number to the
> larger number varies.
>
> I couldnt find any chart types like this, so I was wondering if I need a
> program like Visio or could Excel do it?
>
> Thank you very much
>
> Craig

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Yes, Peter, it needs to be a pie chart...but thanks very much for your input!!

Craig

"Peter Ellis" wrote:

> Does it have to be a Pie Chart. How about a non-stacked line chart in which
> you plot the data series, removing the lines at the end to show only the data
> points.
>
>
> "Craig" wrote:
>
> > Hi,
> >
> > I have a column of 8 labels with 2 columns of data next to it (two numbers
> > for each label). (one of the data columns contains smaller numbers that
> > represent a percentage of the other corresponding number in the other column)
> > I can build a pie chart based on the larger data series so I have 8 slices,
> > but can I also have the small data series displayed as small line arcs within
> > each pie wedge to represent the proportion of the smaller number in the
> > column to the larger number in the other column? The arcs around the inner
> > center area of the pie would vary, since the percentages are different, so it
> > would not be a concentric ring within the pie, but uneven small arcs within
> > each slice, the distance from the absolute center of the pie to each arc
> > varying for each slice since the percentage of the smaller number to the
> > larger number varies.
> >
> > I couldnt find any chart types like this, so I was wondering if I need a
> > program like Visio or could Excel do it?
> >
> > Thank you very much
> >
> > Craig

Thanks Andy...this could be just what I need!!!

"Andy Pope" wrote:

> Hi,
>
> You might find this technique of interest.
> http://www.andypope.info/charts/pieradius.htm
>
> Cheers
> Andy
> Craig wrote:
> > Hi,
> >
> > I have a column of 8 labels with 2 columns of data next to it (two numbers
> > for each label). (one of the data columns contains smaller numbers that
> > represent a percentage of the other corresponding number in the other column)
> > I can build a pie chart based on the larger data series so I have 8 slices,
> > but can I also have the small data series displayed as small line arcs within
> > each pie wedge to represent the proportion of the smaller number in the
> > column to the larger number in the other column? The arcs around the inner
> > center area of the pie would vary, since the percentages are different, so it
> > would not be a concentric ring within the pie, but uneven small arcs within
> > each slice, the distance from the absolute center of the pie to each arc
> > varying for each slice since the percentage of the smaller number to the
> > larger number varies.
> >
> > I couldnt find any chart types like this, so I was wondering if I need a
> > program like Visio or could Excel do it?
> >
> > Thank you very much
> >
> > Craig
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info
>