How to Create a Pie Chart with Excel: 10 Steps

Table of contents:

How to Create a Pie Chart with Excel: 10 Steps
How to Create a Pie Chart with Excel: 10 Steps
Anonim

This article teaches you how to create a graphical representation of the data in Microsoft Excel using a pie chart.

Steps

Part 1 of 2: Enter the Data

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

Step 1. Open Microsoft Excel

Its icon looks like a white "X" on a green background.

If you prefer to create a chart from a data series you already own, double-click the Excel document that contains them and follow the steps in the next section of the article

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

Step 2. Click on New Folder (PC) or Excel Workbook (Mac)

The option is located at the top left of the "Templates" window.

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

Step 3. Name the data series

To do this, click on the cell B1 and type the name you want.

  • For example, if you are creating a family budget table, report in the cell B1 the words "Budget 2017".
  • You can also add a clarifying description, such as "Budget Distribution", in the cell A1.
Make a Pie Chart in Excel Step 4
Make a Pie Chart in Excel Step 4

Step 4. Report the data

You must indicate the potential items that make up the pie chart in the column TO and their values in the column B..

  • Considering the previous budget example, you can type "Car Costs" in A2 and write down "€ 1000" in B2.
  • The pie chart template automatically calculates the percentage share of each item.
Make a Pie Chart in Excel Step 5
Make a Pie Chart in Excel Step 5

Step 5. Complete the data entry

When finished, you can proceed to create the chart.

Part 2 of 2: Generating the Graph

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

Step 1. Select all data

To do this, click in the cell A1, press ⇧ Shift and click in the last column value box B.. This way you select all the data.

If you have used multiple columns and rows, you just need to remember to click in the first cell in the upper left of the data group and in the lower right cell while holding down the ⇧ Shift key

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

Step 2. Click Insert

It's located at the top of the Excel window, just to the right of the section Home.

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

Step 3. Choose the "Pie Chart" icon

This is the circular button in the "Graph" group of options, which in turn is located at the bottom right of the section insert. By doing so, you will see a series of options in the drop-down menu:

  • 2D pie: create a simple pie chart that represents the data with sections of different colors;
  • 3D cake: allows you to generate a three-dimensional graph that shows the data according to a color code.
Make a Pie Chart in Excel Step 9
Make a Pie Chart in Excel Step 9

Step 4. Click on an option

In this way, you create the chart starting from the data you have selected; you should see a legend with the different colors at the bottom of the chart that correspond to the various slices of the pie.

You can view a preview by hovering the mouse pointer over the various models available

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

Step 5. Customize the look of the chart

Select the section Design located in the upper part of the "Excel" window, then click an option among those present in the "Graphic styles" group. This step allows you to change the appearance of the pie, including the color legend, text distribution, and whether or not percentage labels are present.

To view the section Design you must first select the graph area by clicking inside it.

Advice

  • You can copy and paste the table from another Microsoft Office program, such as Word or PowerPoint.
  • If you need to make several tables for several data series, repeat the process described for each of these. When a new table appears, click on it and drag it away from the center of the spreadsheet to avoid hiding the old one.

Recommended: