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

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

A pie chart is a chart based on numerical data that shows proportions in percentages. After making a simple>

Step 1. Open a Microsoft Excel spreadsheet

Enter your data that you want to use to create the pie chart.

Step 2. Create a simple set of data

A pie chart is only used with simple series of data on a particular topic.

For example, you can use a pie chart to track the time you spend on your daily activities. The series of data will then appear in a column with the list of activities, and the other column will show the number of minutes/hours you have spent on it per day. You can use this in a business setting to find the proportional sales of your sales force or the amount of internet traffic you receive from a particular source

Step 3. Save any changes you've made to the spreadsheet before continuing

Part 2 of 3: Selecting data

Step 1. Select the data you want to use in the pie chart

Use your mouse cursor to select all columns to use. Make sure all data series are contiguous.

Make sure you include the names of the categories in the selection. For example, if there is a title at the top of the column such as "Salespersons" and the next column is titled "Sales Numbers", you should include this information as well so that the chart creation wizard uses all the data correctly. can recognize

Step 2. Click "Insert" on the main menu

Select "Graphs" from the list of options.

Step 3. Select the type of pie chart you want to create

The options include a regular pie chart, a 3D pie, or a pie chart with featured segments, a pie-of-pie chart, or a bar-of-pie chart, where part of the pie chart is shown in more detail.

Click the preview button to see what each pie chart will look like

Step 4. Press the "Next" button when you have chosen the type of chart you want

After that, you can customize the pie chart through the "Chart Wizard."

Part 3 of 3: The Chart Wizard

Step 1. Preview your pie chart in the "Chart Source Data" window

Check twice whether the selected range is correct. Indicate whether the data series is in rows or in columns. If you have the data in a column, click on "Columns."

Step 2. Click "Next" to go to the "Chart Options" screen

  • Select the "Title" tab to create a title for your pie chart.
  • Select the "Data Labels" tab to choose the way your data is presented. For example, you can choose from "Category Name" and "Percentage" to show your data in a standard pie chart.

Step 3. Click "Finish" when you are done

Your chart will now appear in the Excel spreadsheet.

Step 4. Copy the file by clicking "Edit" and "Copy" when the entire diagram is selected

Now paste this into a report, Word document or PowerPoint presentation, to support your datasets.

Popular by topic