How to Create a Pie Chart in Excel: 10 Steps (with Pictures)

Table of contents:

How to Create a Pie Chart in Excel: 10 Steps (with Pictures)
How to Create a Pie Chart in Excel: 10 Steps (with Pictures)

Video: How to Create a Pie Chart in Excel: 10 Steps (with Pictures)

Video: How to Create a Pie Chart in Excel: 10 Steps (with Pictures)
Video: How to make Fillable Form in Microsoft Word 2024, November
Anonim

This wikiHow teaches you how to create a visual representation of Microsoft Excel data using a pie chart.

Step

Part 1 of 2: Adding Data

Make a Pie Chart in Excel Step 1
Make a Pie Chart in Excel Step 1

Step 1. Open Microsoft Excel

The program is represented by an icon that looks like a white "E" on a green background.

If you want to create a chart from existing data, double-click the Excel document containing the desired data to open it and move on to the next segment

Make a Pie Chart in Excel Step 2
Make a Pie Chart in Excel Step 2

Step 2. Click Blank workbook (PC) or Excel Workbook (Mac)

It's in the upper-right corner of the "Templates" window.

Make a Pie Chart in Excel Step 3
Make a Pie Chart in Excel Step 3

Step 3. Add a name to the chart

To add a name, click the box “ B1 ” and type a name for the chart.

  • For example, if you want to create a chart of your budget, type for example “2017 Budget” into the “ B1 ”.
  • You can also type an explanatory label (e.g. “Budget Allocation”) in the “ A1 ”.
Make a Pie Chart in Excel Step 4
Make a Pie Chart in Excel Step 4

Step 4. Add data to the chart

Enter the desired pie chart segment label in the “ A ” and the value of the segments in the column “ B ”.

  • For the budget example above, you can write "Car costs" in the column “ A2 ” and put "$1000" in the column “ B2 ”.
  • The pie chart template will automatically determine the percentage.
Make a Pie Chart in Excel Step 5
Make a Pie Chart in Excel Step 5

Step 5. Complete the process of adding data

After completing this process, you are ready to create a pie chart using that data.

Part 2 of 2: Creating Charts

Make a Pie Chart in Excel Step 6
Make a Pie Chart in Excel Step 6

Step 1. Select all data

To select data, click the box " A1 ”, hold down Shift, and click the bottom box containing the values in the column “ B" After that, all chart data will be selected.

If the chart uses multiple columns of letters, numbers, and the like, just remember that you only need to click the farthest column at the top left of the data group and click the farthest column to the bottom right of the data group while holding down Shift

Make a Pie Chart in Excel Step 7
Make a Pie Chart in Excel Step 7

Step 2. Click the Insert tab

This tab is at the top of the Excel window, to the right of the “ Home ”.

Make a Pie Chart in Excel Step 8
Make a Pie Chart in Excel Step 8

Step 3. Click the " Pie Chart " icon (circle/pie chart)

This circle button is in the "Charts" option group, at the bottom right of the tab " Insert " You will see several options in the drop-down menu:

  • 2-D Pie ” – You can create a simple pie chart that displays color-based data segments.
  • 3-D Pie ” – You can use a three-dimensional pie chart that displays color-based data.
Make a Pie Chart in Excel Step 9
Make a Pie Chart in Excel Step 9

Step 4. Click options

After that, a pie chart with the selected data will be created. You can see several colored tabs at the bottom of the pie. The colors correspond to the colored segments of the chart.

You can preview the options by hovering over the different chart templates

Make a Pie Chart in Excel Step 10
Make a Pie Chart in Excel Step 10

Step 5. Modify the appearance of the chart

To modify the view, click the tab “ Design ” at the top of the " Excel " window, then click an option in the " Chart Styles " group. With this option, you can change the appearance of the chart, including the color scheme, text allocation, and the option to show/hide percentages.

To view tabs " Design ”, the chart must already be selected. You can select it by clicking on it.

Tips

  • You can copy the chart and paste it into another Microsoft Office program (eg Word or PowerPoint).
  • If you want to create a chart for multiple data sets, repeat this process for each set. Once the chart is displayed, click and drag the chart from the center of the Excel document outwards so that it doesn't cover/obstruct the first chart.

Recommended: