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. |
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" wrote in message ... 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. |
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" wrote in message ... 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. |
All times are GMT +1. The time now is 01:36 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com