✦Template Printable Ideas Insights

How to Create a Pie Chart from Existing Data in Excel

By

Wouldn't it be great if you could visualize your Excel data with the flick of a wrist? Pie charts are an excellent way to represent data as percentages of a whole, and creating one in Excel is surprisingly simple. Let's dive right in and learn how to create a pie chart in Excel using your existing data.

By the end of this guide, you'll not only have a stunning pie chart ready to impress, but you'll also have a better understanding of Excel's powerful data visualization tools.

Understanding Your Data

Before we get started, it's crucial to understand the structure of your data. For a pie chart, you'll need data thatBreak it down into categories and can be shown as percentages. Here's a simple example: suppose you have sales data for three different products in cells A1 to C4, and you want to show this data as percentages of the total sales.

MS Excel 2016: How to Create a Pie Chart
MS Excel 2016: How to Create a Pie Chart
How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
How to Make a PIE Chart in Excel (Easy Step-by-Step Guide)
Creating a Pie Chart over 100% or 200% in Excel
Creating a Pie Chart over 100% or 200% in Excel

Your data might look something like this:

ProductSales
Apple500
Banana300
Cherry200

Calculating Totals and Percentages

To create our pie chart, we need to calculate the total sales and the sales per product as percentages of the total.

How to Create a Sliced Donut Chart in Excel | Easy Step-by-Step Guide
How to Create a Sliced Donut Chart in Excel | Easy Step-by-Step Guide
Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel
Excel Pie Chart - Introduction to How to Make a Pie Chart in Excel
How to Create a Pie Chart in Excel (Free Template)
How to Create a Pie Chart in Excel (Free Template)

Here's how you can do it:

  • In cell D1, type Total.
  • In cell D2, enter the formula =SUM(B2:B4) to calculate the total sales.
  • In cells E2 to E4, enter the formula =B2/$D$2 (without the dollar signs). This calculates each product's sales as a percentage of the total.

Preparing the Data for the Pie Chart

Now that we have our percentages, we need to combine the product names and their corresponding percentages into a single range of cells. To do this:

  • Clear the contents of cells A5 to C6.
  • In cell A5, type Apple (or any product name from your data).
  • In cell B5, type the corresponding percentage (45.45%).
  • Repeat this process for all products. Your table should now look like this:

    A5B5
    Apple45.45%
    Banana27.27%
    Cherry18.18%

    Creating the Pie Chart

    With our data ready, it's time to create the pie chart. Here's how you can do it:

    Selecting the Data

    Before you can insert a pie chart, you need to select the data you want to use. In this case, select cells A5 to B7.

    Inserting the Pie Chart

    With your data selected, follow these steps to insert the pie chart:

    1. Click on the Insert tab in the toolbar.
    2. In the Charts group, click on the Pie button. A gallery of pie chart options will appear.
    3. Choose the pie chart design you like best. For this example, let's choose the first one (Pie Chart with Legend). Excel will insert the pie chart into your worksheet.

    That's it! You've created a pie chart using your existing Excel data. You can now customize the chart's look and feel, add a title, or change the legend's position to make it even more engaging.

    So, what's next? Maybe you'll try creating a bar chart or a line graph to visualize different aspects of your data. Or perhaps you'll use Excel's other powerful features to clean, analyze, or transform your data. The possibilities are endless, and the results can be incredibly insightful. Keep exploring, and happy data visualizing!

Learn how to create attractive Pie Charts in Excel
Learn how to create attractive Pie Charts in Excel
How to Create a Half Pie Chart in Excel
How to Create a Half Pie Chart in Excel
How-to Create a Dynamic Excel Pie Chart
How-to Create a Dynamic Excel Pie Chart
How To Create A Pie Chart In Excel (With Percentages)
How To Create A Pie Chart In Excel (With Percentages)
How to create a Pie chart in PowerPoint
How to create a Pie chart in PowerPoint
How to Create a Pie Chart in Microsoft Excel
How to Create a Pie Chart in Microsoft Excel
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
How to Create a Pie Chart in Google Sheets: A Simple Step-by-Step Guide (With Example)"
Excel How to Create Pie Charts Tutorial
Excel How to Create Pie Charts Tutorial
Ever wondered how to create a stunning donut chart in Excel? 🍩
Ever wondered how to create a stunning donut chart in Excel? 🍩