Multiple pie charts

djl0525

Well-known Member
Joined
Dec 11, 2004
Messages
1,235
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
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.

tusharm

MrExcel MVP
Joined
May 28, 2002
Messages
11,028
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
 

Watch MrExcel Video

Forum statistics

Threads
1,118,701
Messages
5,573,704
Members
412,548
Latest member
wallisonlac
Top