How to Create a Pie Chart in Microsoft Excel

Date:2020-2-8 Author:Cordelia

Pie chart is one of the most common used charts in Excel. It’s often used in market share analysis, market occupancy analysis and some other occasions since it can express the proportion of each area intuitively.

The way to insert a pie chart in Excel is much like the method of making a line chart, which I’ve introduced in my previous post.

1. First of all, you need a table shows the proportion of each part in the total quantity as source data.

How to Create a Pie Chart in Microsoft Excel

2. Click Insert, then the icon of pie chart. Choose the style you like.

How to Create a Pie Chart in Microsoft Excel

3. Click Select Data and hit the small icon beside Chart data range in the popping out window.

How to Create a Pie Chart in Microsoft Excel

4. Select the range of data manually till the description is added to the textbox automatically. Hit that small icon again to go back to Select Data Source window.

How to Create a Pie Chart in Microsoft Excel

5. Check the content in Legend Entries (Series) and Horizontal (Category) Axis Labels.

How to Create a Pie Chart in Microsoft Excel

6. Click OK then these data will be applied to the new chart. You can customize the style and color by clicking the brush icon next to it.

How to Create a Pie Chart in Microsoft Excel

Copyright Statement: Regarding all of the posts by this website, any copy or use shall get the written permission or authorization from Myofficetricks.

One response to “How to Create a Pie Chart in Microsoft Excel”

  1. vurtilopmer says:

    Glad to be one of many visitors on this awesome internet site : D.

Leave a Reply

Your email address will not be published. Required fields are marked *