How to make a pie chart in Excel

How to Make a Pie Chart in Microsoft Excel Mahesh Makvana @maheshhari December 3, 2021, 11:00am EDT Karramba Production/Shutterstock.comUsing pie charts allows you to i

How to make a pie chart in Excel

How to Make a Pie Chart in Microsoft Excel

  • Mahesh Makvana

@maheshhari

  • December 3, 2021, 11:00am EDT
3D pie chart on a grey background

Karramba Production/Shutterstock.com

Using pie charts allows you to illustrate the distribution of data in the form of slices. Its easy to make 2D, 3D, or doughnut-style pie charts in Microsoft Excelno design knowledge necessary! Heres how to do it.

How to Create a Pie Chart in Excel

To create a pie chart in Excel, first, open your spreadsheet with the Excel app. Well use the following spreadsheet for this guide:

The data for a pie chart in Excel.

In your spreadsheet, select the data that you want to plot on your pie chart. Do not select the sum of any numbers as you probably dont want to display it on your chart.

Select the data for pie chart.

Advertisement

While your data is selected, in Excels ribbon at the top, click the Insert tab.

Click the "Insert" tab in Excel.

In the Insert tab, from the Charts section, select the Insert Pie or Doughnut Chart option (its shaped like a tiny pie chart).

Select "Insert Pie or Doughnut Chart" in the "Insert" tab in Excel.

Various pie chart options will appear.

The Best Tech Newsletter Anywhere

Join 425,000 subscribers and get a daily digest of features, articles, news, and trivia. Sign Me Up! We've got your info - thanks for signing up! We were unable to subscribe you! Please check your e-mail address or contact us for assistance. Signing you up...

By submitting your email, you agree to the Terms of Use and Privacy Policy.

Pie chart options in Excel.

To see how a pie chart will look like for your data, hover your cursor over the chart and a preview will appear.

Hover over a pie chart.

Once you decide on a chart, click that chart to add it to your spreadsheet.

Select a pie chart.

Advertisement

The chart is now available in your spreadsheet. To change the charts header, double-click the header and enter a new name.

Double-click the pie chart header.

You can change the charts position in your spreadsheet by dragging and dropping the chart. Theres an option to lock the position of your chart as well.

And thats how you go about displaying your Excel data using slices on a pie!

RELATED: How to Lock the Position of a Chart in Excel

How to Customize the Pie Chart in Excel

The default pie chart design looks good on its own, but you can customize it if you want.Advertisement

To do so, click your chart so its selected. Then, in Excels ribbon at the top, click the Chart Design tab.

Click the "Chart Design" tab in Excel.

In the Chart Design tab, you will find various chart customization options. If youd like to change your charts color scheme, click the Change Colors option and pick a new scheme.

Click "Change Colors" in the "Chart Design" tab in Excel.

Similarly, to change your charts style, pick a new design from the Chart Styles section.

Select a pie chart style from "Chart Styles" in Excel.

Lastly, if you want to use your chart outside of Excel, save the chart as an image file by right-clicking the chart and selecting Save as Picture.

Right-click a pie chart and select "Save as Picture."

Advertisement

And thats how you personalize your pie charts in Microsoft Excel. If youre creating a handout, you may want to save your Excel sheet as a PDF before printing it.


Making multiple pie charts in your spreadsheets? You can alsogroup your charts with an Excel feature.

RELATED: How to Combine or Group Pie Charts in Microsoft Excel

Mahesh Makvana

Mahesh Makvana
Mahesh Makvana is a freelance tech writer who specializes in writing how-to guides. He has been writing tech tutorials for over a decade now. Hes written for some of the prominent tech sites including MakeUseOf, MakeTechEasier, and Online Tech Tips. Read Full Bio »

Video liên quan