Tips for creating a pie chart in Excel

Source: Internet
Author: User
See http://www.hongen.com/pc/oa/excel2k/ex2k0704.htm

We can often see a pie chart with a part separated from other parts. The practice of this chart is: click this pie and some handles appear around the pie,
Click a color block and handle it to the surrounding area of the Color Block. Then, drag the color block outward to drag it out.
The parts are separated.
To combine them, click the blank area of the chart, cancel the selection of the pie, click the color block of any pie, select the entire pie, and press the left button
Drag the mouse inside to merge the pie.

 

 

We often see such a pie chart: Take a small portion of the total amount separately and make a small pie for clarity. To do this, open the "chart"

Menu, click the "chart type" command, open the "chart type" dialog box, click the "standard type" tab, and select "composite pie chart" from the "subchart type" list ",

Click OK to generate the chart.

If the positions of each part in the graph do not meet the requirements, adjust the size of the graph first, and then drag the portion of the pie chart on the right to the left,

At the same time, drag the small portion on the left to the right, and the pie chart is complete.
A three-dimensional pie chart is also frequently used. Let's use this chart to change it: open its "chart type" dialog box and select it in the "subchart type" list.

Click "3D pie chart" and click "OK. If the generated chart is not easy to view, you can modify it as appropriate: Open the "chart" menu and click "set 3D view ".

Graph format command to open the "set 3D view format" dialog box. Here, you can modify the elevation, rotation angle, and height of a 3D image until you are satisfied.

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.