How to Create a Pie Chart in Excel and Google Sheets

-

|

Introduction

This guide demos how to create a pie chart in Excel and Google Sheets. A pie chart is a circular representation of a data set in portions.

In other words, a pie chart shows portions of a whole set of data in a circular form.

How to Create a Pie Chart in Excel

To create a pie chart in Excel you need a set of data. Here is the data I will use for my demo in this guide.

How to Create a Pie Chart in Excel

The excel sheet is a monthly sales data for an online retailer.

Here are the steps to create a pie chart in Excel with this data.

  • Highlight all the data including its headers.
How to Create a Pie Chart in Excel
  • Then with the data selected, click Insert tab.
How to Create a Pie Chart in Excel
  • When you click Insert, it will display a set of options. One of them is Charts group (highlighted in the image below).
How to Create a Pie Chart in Excel
  • In the Charts group, click on Pie chart icon (highlighted in the image below)
  • Then select Pie (first option), Pie of pie (second option) or bar of pie (third option). When you hover over a pie chart type, Excel will display the image of the pie chart beneath.
Excel also supports two other types of Pie charts – 3-D pie chart or Doughnut pie. See the images below.
  • Once you select a pie chart type, the chart will display on the data. Move the pie chart away from the data.

How to Create a Pie Chart in Google Sheets

Just like excel you can also create a Pie chart in Google Sheets.

I will use the data in the Google Sheets shown below to demo how to create pie chart in Google Sheets.

How to Create a Pie Chart in Excel and Google Sheets

Here are the detailed steps to create a pie chart in Google Sheets:

  • Highlight all the data including the headers.
How to Create a Pie Chart in Excel and Google Sheets
  • Then click Insert tab and click Chart.
How to Create a Pie Chart in Excel and Google Sheets
  • When you click Chart, Google Sheets will select Line chart by default. To change the chart type to Pie chart, click the drop-down arrow beside Line chart (see the image below). Then select Pie chart.
  • If you wish to customize the chart, click the Customize tab (see the image below).
  • Finally, click the x sign on top of the chart insert tool to close it.
  • Then move your pie chart away from your data. You may also resize your chart…

Conclusion

I hope you found this guide useful.

If you have a question, comment or feedback use the “Leave a Reply” form found at the end of this page.

For more Windows guides visit our Windows How To page.

  • Was this post Helpful?
  • YesNo

LEAVE A REPLY

Please enter your comment!
Please enter your name here

FEATURED POSTS

How to Print Facebook Messages

How to Print Facebook Messages (Directly or from Microsoft Word)

This Itechguide teaches you how to print Facebook messages. You can print Facebook messages directly from Facebook. Or...
How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Change Default Font in Google Docs

How to Change Default Font in Google Docs

This Itechguide teaches you how to change default font in Google Docs. Here are the high-level steps to change default font in...
How to Print Google Slides with Notes

How to Print Google Slides with Notes

This Itechguide teaches you how to print Google Slides with notes.

ADVERTISEMENTS

TRENDING POSTS

Remote Desktop Connection

Remote Desktop Connection an Internal Error Has Occurred [Fixed]

Introduction I recently received the error message "Remote Desktop Connection an Internal Error Has Occurred". It was strange because...

Find My Samsung: Register and Use Samsung Find my Mobile

Introduction Ever wondered how you could find your Samsung phone if you lost it? Find my Samsung or Samsung...
What is the Difference Between PowerShell and CMD?

Windows Powershell vs CMD: Differences and Similarities

Introduction This short guide compares Windows PowerShell vs CMD (Windows command prompt). I will cover the history and nature...
Spotify No Longer Supports this Version of Microsoft Edge

Spotify No Longer Supports this Version of Microsoft Edge [Fixed]

Introduction When you open Spotify web player on Microsoft Edge, you may receive the error message "Spotify No Longer...
Windows 10 Won't Boot

Windows 10 Won’t Boot With Black Screen? 3 Ways to Fix It

Why Won't Windows 10 Boot Up? If your Windows 10 stops with a black screen, the first question in...

BEST OF ITECHGUIDES

how to login to spotify without facebook

How to Login to Spotify Without Facebook

This guide shows you how to login to spotify without Facebook if you are creating a new Spotify account or if you...
windows modules installer worker high cpu 2

How to Fix Windows Modules Installer Worker High CPU

Introduction If Windows Modules Installer Worker has high CPU usage, it may slow your computer down. Windows Modules Installer...
How to Delete Hotmail Account (Outlook.com Account)

How to Delete Hotmail Account (Outlook.com Account)

Introduction This guide demos how to delete Hotmail account. Hotmail.com has been replaced by Outlook.com.
bullet points in excel

4 Easy Ways to Insert Bullet points in Excel

Introduction Inserting bullet points in excel is not as straightforward as adding bullet points in Word. This guide demonstrates...
How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:

ADVERTISEMENTS

RECENT POSTS

How to Print Facebook Messages

How to Print Facebook Messages (Directly or from Microsoft Word)

This Itechguide teaches you how to print Facebook messages. You can print Facebook messages directly from Facebook. Or...
How to Embed YouTube Video on Facebook

How to Embed YouTube Video on Facebook

This Itechguide teaches you how to embed YouTube video on Facebook. There are 2 high-level steps discussed in this guide:
How to Cancel Amazon Music Unlimited

How to Cancel Amazon Music Unlimited (PC or Amazon Apps)

This Itechguide teaches you how to cancel Amazon music unlimited. It offers steps to cancel Amazon music unlimited from a PC, Amazon...
How to Add to outline in google docs

How to Add to Outline in Google Docs

This Itechguide teaches you how to add to outline in Google Docs. The guide offers steps to add to outline in Google...
How to Go Frame by Frame in YouTube

How to Go Frame by Frame in YouTube

This Itechguide teaches you how to go frame by frame in YouTube. YouTube does not have an inbuilt tool that allows you...

MUST READ

How to Uninstall a Program in Windows 10

How to Uninstall a Program in Windows 10 (3 Methods)

Introduction This guide demos how to Uninstall a Program in Windows 10. Options to Uninstall...
How to Convert Windows 10 Install.esd to Install.wim

How to Convert Windows 10 Install.esd to Install.wim (2 Methods)

Introduction This guide demos 2 methods to convert ESD to WIM (Install.esd to Install.wim). Though...
Group Policy, GPResult, Group Policy Object and RSoP

Group Policy, Group Policy Object and RSoP Explained

Introduction This guide gives an overview of Group Policy, RSoP (Resultant Set of Policy) and Group Policy Objects.
Windows Server 2016 Interview Questions and Answers

Windows Server 2016 Interview Questions and Answers

Introduction This guide provides common Windows Server 2016 interview questions and answers. The questions are...
Best Action Movies onNetflix

The 10 Best Action Movies on Netflix

There are quite a number of action movies on Netflix. It is definitely not all that will give you that desired experience.

LATEST DEALS

Exclusive Student Offer_Save 10% on selected Surface devices

By using this website you agree to accept our Privacy Policy and Terms & Conditions