How do you create a multiple pie chart?
e.g. if you have 3 groups A, B and C, each which 3 different category X, Y
and Z.
Is it possible to put it all into one chart?
I have done it but it has to be done individually and it takes time.
How do you create a multiple pie chart?
e.g. if you have 3 groups A, B and C, each which 3 different category X, Y
and Z.
Is it possible to put it all into one chart?
I have done it but it has to be done individually and it takes time.
There's no chart type that combines multiple independent pies in the same
chart. Your approach (three sepaarate charts) is how I would do it.
Unless you want to try one of the approaches in this article:
http://pubs.logicalexpressions.com/P...cle.asp?ID=471
These look great, combining the data into a single apparent chart, but they
actually also use multiple charts, and also take time and effort.
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
"James" <[email protected]> wrote in message
news:[email protected]...
> How do you create a multiple pie chart?
>
> e.g. if you have 3 groups A, B and C, each which 3 different category X, Y
> and Z.
>
> Is it possible to put it all into one chart?
>
> I have done it but it has to be done individually and it takes time.
hey thanks. That was good enough. Will see what i can do with it.
"Jon Peltier" wrote:
> There's no chart type that combines multiple independent pies in the same
> chart. Your approach (three sepaarate charts) is how I would do it.
>
> Unless you want to try one of the approaches in this article:
>
> http://pubs.logicalexpressions.com/P...cle.asp?ID=471
>
> These look great, combining the data into a single apparent chart, but they
> actually also use multiple charts, and also take time and effort.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
> "James" <[email protected]> wrote in message
> news:[email protected]...
> > How do you create a multiple pie chart?
> >
> > e.g. if you have 3 groups A, B and C, each which 3 different category X, Y
> > and Z.
> >
> > Is it possible to put it all into one chart?
> >
> > I have done it but it has to be done individually and it takes time.
>
>
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks