How to Make a Pie Chart in Excel

Part 1 of 2:

Adding Data

  1. How to Make a Pie Chart in Excel Picture 1
    Open Microsoft Excel. It resembles a white "E" on a green background.
    1. If you would rather make a chart from data you already have, double-click the Excel document that contains the data to open it and proceed to the next section.
  2. How to Make a Pie Chart in Excel Picture 2
    Click Blank workbook (PC) or Excel Workbook (Mac). It's in the top-left side of the "Template" window.
  3. How to Make a Pie Chart in Excel Picture 3
    Add a name to the chart. To do so, click the B1 cell and then type in the chart's name.
    1. For example, if you're making a chart about your budget, the B1 cell should say something like "2017 Budget".
    2. You can also type in a clarifying label--e.g., "Budget Allocation"--in the A1 cell.
  4. How to Make a Pie Chart in Excel Picture 4
    Add your data to the chart. You'll place prospective pie chart sections' labels in the A column and those sections' values in the B column.
    1. For the budget example above, you might write "Car Expenses" in A2 and then put "$1000" in B2.
    2. The pie chart template will automatically determine percentages for you.
  5. How to Make a Pie Chart in Excel Picture 5
    Finish adding your data. Once you've completed this process, you're ready to create a pie chart using your data.
Part 2 of 2:

Creating a Chart

  1. How to Make a Pie Chart in Excel Picture 6
    Select all of your data. To do so, click the A1 cell, hold down Shift, and then click the bottom value in the B column. This will select all of your data.
    1. If your chart uses different column letters, numbers, and so on, simply remember to click the top-left cell in your data group and then click the bottom-right while holding Shift.
  2. How to Make a Pie Chart in Excel Picture 7
    Click the Insert tab. It's at the top of the Excel window, just right of the Home tab.
  3. How to Make a Pie Chart in Excel Picture 8
    Click the "Pie Chart" icon. This is a circular button in the "Charts" group of options, which is below and to the right of the Insert tab. You'll see several options appear in a drop-down menu:
    1. 2-D Pie - Create a simple pie chart that displays color-coded sections of your data.
    2. 3-D Pie - Uses a three-dimensional pie chart that displays color-coded data.
  4. How to Make a Pie Chart in Excel Picture 9
    Click an option. Doing so will create a pie chart with your data applied to it; you should see color-coded tabs at the bottom of the chart that correspond to the colored sections of the chart itself.
    1. You can preview options here by hovering your mouse over the different chart templates.
  5. How to Make a Pie Chart in Excel Picture 10
    Customize your chart's appearance. To do so, click the Design tab near the top of the "Excel" window, then click on an option in the "Chart Styles" group. This will change the way your graph looks, including the color schemes used, the text allocation, and whether or not percentages are displayed.
    1. To view the Design tab, your chart must be selected. You can select a chart by clicking it.

Sample Pie Charts

How to Make a Pie Chart in Excel Picture 11 Sample Pie Chart About Time
How to Make a Pie Chart in Excel Picture 12 Sample Pie Chart About Food
How to Make a Pie Chart in Excel Picture 13 Sample Pie Chart About Sports
4.5 ★ | 2 Vote

May be interested

  • How to create a pie chart in Microsoft ExcelHow to create a pie chart in Microsoft Excel
    pie charts are a great tool for visualizing information. it allows users to see the partial relationship with the entire data.
  • How to draw a bar chart in ExcelHow to draw a bar chart in Excel
    how to draw a bar chart in excel. a bar chart is a chart that is used quite a lot, this is a chart that displays many different types of data with a rectangular column, the longer the bar, the greater the value. there are two types of bar charts: vertical and vertical charts
  • How to draw a line chart in ExcelHow to draw a line chart in Excel
    how to draw a line chart in excel. a line chart shows continuous data over time on an evenly divided axis, so a line chart is suitable for representing data trends at equal time periods like months, quarters or years.
  • How to create a pie chart in ExcelHow to create a pie chart in Excel
    pie charts are a regular way to show things through data, which help your paper be scientific and attract readers. the following article details how to create a pie chart in excel.
  • Hide and show chart labels in ExcelHide and show chart labels in Excel
    the following article will guide you in detail how to show / hide chart labels in excel. for example, the following chart is created: 1. want to add revenue details for employees displayed on the chart do the following.
  • How to Create a Multi-Line Chart in ExcelHow to Create a Multi-Line Chart in Excel
    drawing a multi-line chart in excel is very simple! if your spreadsheet has multiple groups of data, you can view the data visually by creating a chart with multiple lines. you can create a new chart or add lines to an existing chart. this article will show you how to create a multi-line chart
  • How to draw a map chart on ExcelHow to draw a map chart on Excel
    in excel 2019, there is a map diagram, showing the names of countries in the world.
  • Create Excel charts that automatically update data with these three simple stepsCreate Excel charts that automatically update data with these three simple steps
    excel charts help shorten the decision-making process, because we can immediately see the results and things to change. however, the difficulty in processing data and charts is that users must constantly return to the chart and update new data. yes, this problem will be gone when you follow these three simple steps to create an excel chart that automatically updates data.
  • How to create a frequency chart in ExcelHow to create a frequency chart in Excel
    how to create a frequency chart in excel. with the frequency chart you can determine the frequency of occurrence of the event, the variability ... the following article gives detailed instructions on how to create frequency charts in excel.
  • How to Add a Second Y Axis to a Microsoft Excel ChartHow to Add a Second Y Axis to a Microsoft Excel Chart
    it would be helpful if you knew how to add multiple data lines to an excel chart. however, with data with many units, you may find it difficult to create the graph you need. don't worry, not only can you do it, you can do it very easily!