How does Excel make pie charts?

Source: Internet
Author: User

Pie charts are one of the basic graphic types of Excel, and we usually use pie charts to represent each item's ratio, and sometimes we see a semicircle pie chart, but there's no such type in Excel, so how do we make it?

1, open excel2013, the other version of the operation is virtually the same, enter the various project categories of data, as shown in the figure, and then summary statistics, the results are placed at the bottom of the list, as shown in the figure

2, first the data to sort, descending, all selected data, including the results of the summary, click Insert, select Pie chart, using the most basic two-dimensional pie chart on the line

3, the table has generated a pie chart, the left side of the blue figure is the summary of the data ratio of the results, select the pie, right-click, select Set data series format

4, on the right side of Excel to find the first sector starting position, enter 270 degrees, that is, starting from-90 degrees, as shown, the original left side of the blue graphics transfer to the bottom of the position

5. Click on the blue Area two times, select it, in the right data series format, switch to color, click the set fill color for a solid fill, select pure white in the color, so that in the white background can not see the following section, the initial display of the semicircle pie chart

6, select the pie chart, on the right side of the data label settings, check the percentages and data labels, cancel the value, display position in the data label, as shown

7, on the pie chart to select the data labels, each of the label's hundred points to expand twice times the manual input, finished can use this pie chart

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.