Multi level Excel charts

[LHM]

Hi everyone...I am trying to plot below table in a pie chart format, but I am unable to do so. Anyone has any ideas?　






POST MOVED BY MODERATOR


.

 

[bobhc]

Anyone has any ideas?

Not really as you say very little about the problem you are having, what problem are you having in selecting the data, perhaps if you uploaded the worksheet with the data it could be worked on instead of a picture that does not say a thousand words!!

 

[LHM]

I have uploaded the file I need help with. I need help to create a multi level pie chart please.

 

[Awesome Wally]

Based on your data I'm not really sure which level(s) of data you are attempting to chart. Attached below is a simple tutorial for reference.
http://www.officetooltips.com/excel/tips/using_pie_charts_and_doughnut_charts_in_excel.html

 

[AVK]

Dear LHM, Welcome & happy christmas!
As per your data, i think you can apply stacked column chart instead of pie chart.

Pie Chart : A pie chart represents the distribution or proportion of each data item over a total value (represented by the overall pie). A pie chart is most effective when plotting no more than three categories of data.

Stacked Chart : A stacked column chart allows you to compare items in a specific range of values as well as show the relationship of the individual sub-items with the whole.
Please refer attach file.