make pie chart from excel column

Easily Create Pie Charts from Excel Columns

By Ashley Young
AD

Creating eye-catching visualizations like pie charts from your Excel data can help communicate complex information more effectively. This guide will walk you through the process of generating a pie chart from an Excel column, so you can transform numbers into engaging, shareable insights.

Whether you're presenting financial data, sales targets, or market shares, a well-crafted pie chart can simplify these figures and make them more digestible. Let's dive in and turn those Excel columns into compelling pie charts.

Preparing Your Data in Excel

Before creating your pie chart, ensure your data is clean and organized. For this guide, let's assume you have a simple Excel worksheet with two columns: 'Category' (e.g., Fruits, Vegetables, Meats) and 'Sales' (with corresponding sales figures).

AD
How to Make Pie of Pie Chart in Excel (with Easy Steps) - ExcelDemy
How to Make Pie of Pie Chart in Excel (with Easy Steps) - ExcelDemy
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)
the pie chart shows that there are many different types of food
the pie chart shows that there are many different types of food

To create a pie chart, ensure your data is sorted correctly. In our example, 'Category' will form the pie slices, while 'Sales' will determine their sizes.

Sorting Your Data

To sort your data by 'Category', click on the 'Data' tab in the Excel ribbon. Then, click on 'Sort' and select 'Sort by Category' under the 'Sort A' drop-down menu. Ensure that the 'Sort on' field is set to 'Category' and click 'OK'.

How to Make a Pie Chart in Excel: 5 Suitable Methods - ExcelDemy
How to Make a Pie Chart in Excel: 5 Suitable Methods - ExcelDemy
Curious
Curious
MVP #34: Pie Charts and Column Charts in Excel
MVP #34: Pie Charts and Column Charts in Excel

Now, your categories are sorted alphabetically—an essential step for creating visually appealing pie charts.

Removing Empty Rows

Before generating your pie chart, make sure there are no empty rows between your data. Select your data range, clicked 'Data' > 'Remove Duplicates' to eliminate any empty rows that might disrupt your chart.

AD

A clean dataset ensures your pie chart is visually accurate and insightful.

How to Make Multiple Pie Charts from One Table (3 Easy Ways) - ExcelDemy
How to Make Multiple Pie Charts from One Table (3 Easy Ways) - ExcelDemy
How to Make Pie Chart in Excel with Subcategories (with Easy Steps) - ExcelDemy
How to Make Pie Chart in Excel with Subcategories (with Easy Steps) - ExcelDemy
How to Create a Pie Chart in Excel with One Data Column - 2 Methods - ExcelDemy
How to Create a Pie Chart in Excel with One Data Column - 2 Methods - ExcelDemy
an excel chart with the pie chart section highlighted
an excel chart with the pie chart section highlighted
Create a pie chart from distinct values in one column by grouping data in Excel
Create a pie chart from distinct values in one column by grouping data in Excel
Infographics: Filling Circle Chart in Excel
Infographics: Filling Circle Chart in Excel

Creating Your Pie Chart in Excel

Now that your data is well-prepared, let's create your pie chart. Highlight your data range, then click on the 'Insert' tab in the Excel ribbon. In the 'Charts' group, select 'Pie' and choose the pie chart sub-type that best fits your data.

The 'Exploded' pie chart is a popular choice for highlighting a specific category in your data. Let's proceed with that.

AD

Choosing a Pie Chart Variation

After selecting the 'Exploded' pie chart, you'll see a preview of your chart. Click on it to apply the chart to your worksheet. Excel will automatically select the 'Category' column for the 'Legend entries (langan)' field and the 'Sales' column for the 'Series' field.

Create a Pie Chart in Excel
Create a Pie Chart in Excel

Your basic pie chart is now created, and Excel has made intelligent assumptions about how to structure your data. However, let's fine-tune it to ensure it's analytically sound and visually appealing.

Customizing Your Pie Chart

To access the chart elements, click anywhere in the pie chart to see the 'Chart Design' and 'Format Selection' tabs under the 'Chart Tools' section in the ribbon. Here, you can customize the chart title, legend, and color schemes to match your presentation or report.

AD

For example, adjust the chart title to 'Sales Distribution' and modify the legend position and font size to make it more visible. You can also change the color scheme to match your brand or presentation theme.

Creating engaging pie charts from Excel data involves careful preparation, intelligent use of Excel's built-in tools, and thoughtful customization. By following these steps, you'll transform your raw data into insightful, shareable visuals that communicate your message effectively.

AD