Multiple pie charts

[djl0525]

In Lotus 123 you can create a chart that consists of multiple pie charts based on more than one series of data. It looks like you created 4 pie charts, but you really only created one. I don't see any default or custom charts like this in Excel. Does anyone know of any sites that offer a way to do this? With or without VB?

Thank you in advance for your consideration,
DJ

 

[tusharm]

In XL you can create a pie chart from only one series. [Well, you can specify multiple series but XL will use only one.]

You can always create 4 charts, each as an object in a worksheet (or a chart sheet for that matter). Format them so that they look like a single chart. For an example of how to make multiple charts look like a single entity see
Stacked Charts
http://www.tushar-mehta.com/excel/newsgroups/stacked_charts/index.html

 

[djl0525]

Thanks! -- DJ

 

[tusharm]

You are welcome.