How to make an intuitive two-pie chart in Excel2013

Source: Internet
Author: User

How to make an intuitive two-pie chart in Excel2013

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.

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.