 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
11-22-2005, 06:20 AM
|
|||
|
|||
|
Multiple Pie Chart - How?
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. 
|
|
#2
11-22-2005, 09:10 AM
|
|||
|
|||
|
Re: Multiple Pie Chart - How?
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" <James@discussions.microsoft.com> wrote in message news:6B638AB8-5272-4E43-BB44-919C234ED558@microsoft.com... > 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.
|
|
#3
11-25-2005, 12:15 AM
|
|||
|
|||
|
Re: Multiple Pie Chart - How?
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" <James@discussions.microsoft.com> wrote in message > news:6B638AB8-5272-4E43-BB44-919C234ED558@microsoft.com... > > 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. > > >
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
