Pie and Donut Combined

In the attachment I found an image that I am trying to create.  My question is it possible to create the pie/donut graph using basic excel or would it have to be created with VBA?
EE-example-2013.09.16.xlsx
jmac001Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

jmac001Author Commented:
Also does it make a difference if the data comes from a pivot table?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you can create a pie surrounded by a doghnut chart with these steps:

- select the data for the doughnut chart and build a doughnut
- select the chart and click Select Data on the Chart Tools - Design ribbon.
- add a new data series with the series name and the series values of the inner pie chart.
- the result will be two nested doughnut charts.
- Select the inner doughnut series and change the chart type to pie.

Disclaimer: Pie and doughnut charts should not be used for many data values. The example you post is a classic for a bad pie chart. Data is much easier to interpret with bar or column charts.

If your source data is a pivot table, you will need to copy and paste the data somewhere else, since Pivot Charts don't work with some chart types or with combination charts.

See attached file, Sheet2 for a doughnut/pie example and a column chart that is much easier to read for comparing values.

cheers, teylyn
EE-example-2013.09.16.xlsx
0
Steven HarrisPresidentCommented:
It’s not so much a pie chart as it is a donut chart with about 40 series, the inner 30 sharing the same data, so they seem to make a single wedge.

In short that is a multi-layered Donut Chart (aka - Radial Treemap)!

Check this Blog entry for more information.
0
CompTIA Network+

Prepare for the CompTIA Network+ exam by learning how to troubleshoot, configure, and manage both wired and wireless networks.

jmac001Author Commented:
Hi teylyn and thinkspacesolutions,

Thanks for the info.  Teylyn unfortunately the request is for a pie chart. From my example data you can see we are looking at reason codes... so they would like to see the percentage of the reason codes in the data then a high level percentage based on grouping of like reason codes.  I guess my biggest problem is placing the data into a chart format that is going to give me the result that I am looking for any ideas?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
The problem (if you do this with Excel) is this:

You can have a combination of ONE doughnut and ONE pie in a chart, where the pie is inside the doughnut. It actually sits BEHIND the doughnut.

Doughnuts don't support leader lines out of the box. The workaround is to have a combination doughnut/pie where the pie has the leader lines and is then formatted to be invisible by turning the fill off for each wedge individually. See my article here for details: http://www.teylyn.com/articles/excel-articles/excel-doughnut-chart-with-leader-lines/

So, to have a doughnut with leader lines, you'll need to use ONE pie already.

After that, you cannot have another pie sit in the center of the doughnut. Excel does not support it.

The best workaround I could find is to have an inner doughnut instead of an inner pie.

See attached. That's hitting the limits of Excel.

cheers, teylyn
EE-example-2013.09.16.xlsx
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
jmac001Author Commented:
teylyn,

Three questions, 1) is it possible to have the donut line up with the the outer donut?  2) if it is possible to line up the inner donut to the outer donut based on the grouping of codes, is possible to have the enter donut to be one of the colors of the outer donut?  3) Is it possible to achieve this in VBA?
0
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
What do you mean with "line up"?  The inner and the outer donuts have a different number of data points. In each donut, the first data point starts at the 12 o'clock position. This is where the two donuts are lined up. From then onwards, in a clockwise direction, each data point will be rendered according to its value.

Doing this in VBA may be possible, but would require a big chunk of charting VBA expertise.
0
[ fanpages ]IT Services ConsultantCommented:
"Pie and Donut Combined"?

...all the major food groups in one question.

Yum.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.