How Excel data changes intuitive two-pie chart

when using Excel tables for data statistics, in order to look more intuitive, it is often necessary to store different kinds of data in the Peer (column). However, sometimes the different kinds of data to be counted are mixed in the same row (column), it is difficult to see the relationship between each other. In this case, we can use a two-pie graph to visually represent the relationship of the data.

Like the data in this table, although the data is not much, but can only roughly see vegetables, electrical appliances, fruit 3 categories, and 3 kinds of fruit did not calculate the total. From this form, it is difficult to see the comparison between the volume of 3 items.

But is it much more intuitive to turn the data into a chart like the following?

So how does this chart work? Please come with me

First you open the datasheet, select the range of data you want to make the chart, and then select Insert → chart → insert pie or doughnut-pie, and pie-bar, and then you can get a basic composite pie chart prototype.

However, this chart also lacks the necessary annotation, only uses the legend color annotation, you many by the color control view, can understand its relation, this obviously is not obvious enough.

Select a style with the Chinese character name callout from the chart styles list, which is closer to our goal. However, we found that "Chang", Excel did not understand what we mean, only bananas and apples for a class, and the wrong way to put Sydney into another separate category, this is obviously not common sense. We need to correct it.

Double-click the chart area, set the data series format in the right window, change the value in the second drawing area from 2 to 3, and then enter to determine.

Then look at the style of the chart, Apple, Banana, Sydney grouped into a category, has been correctly categorized.

For other annotations that don't look good or appropriate, just double-click to edit the input again.

For simplicity's sake, this example simply enumerates a few data. For data categories More tables, the method of making the same principle. Just be aware that putting a variety of items with a level two classification into the end of a table is OK.