[SOLVED] Pie chart with three fields in Ms Excel

Pie chart with three fields in Ms Excel

I want to make three field pie chart with label name and three colors. But i am not able to do.

What I have tried :

Select all fields
Insert -> pie chart

But this does not work at all :(

This is my sample data :

year    test2   test3
2010    20     25000
2011    100    81000
2012    1      17000
2013    1      22000
2014    2      11000
2015    1      12000
2016    2      20000
2017    3      30000

Please help :)

Solution

I stand corrected: you actually can make a "multi-level pie chart" in Excel:

Here are instructions from BrainBell.

Apparently it can be a little tricky. I've never seen multi-axis pie chart before, but some of them and kinda neat..

These ones can't be easily created by Excel, but may be possible with plugins with Javascript:

^{(Click images for source page)}

...and while we're looking at pretty, round data:

^{Click images for source pages)}