If you did, please spare a few minutes to share your thoughts with Itechguides Community Forum.įurthermore, if you have any questions, comments, or feedback please them to Itechguides Community Forum. Then move your pie chart away from your data.Finally, click the x sign on top of the chart insert tool to close it.If you wish to customize the chart, click the Customize tab (see the image below).To change the chart type to Pie chart, click the drop-down arrow beside Line chart (see the image below). When you click Chart, Google Sheets will select Line chart by default.Highlight all the data including the headers.Here are the detailed steps to 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. Just like excel you can also create a Pie chart in Google Sheets. How to Create a Pie Chart in Google Sheets

Once you select a pie chart type, the chart will display on the data.

When you hover over a pie chart type, Excel will display the image of the pie chart beneath.Įxcel also supports two other types of Pie charts – 3-D pie chart or Doughnut pie.

Then select Pie (first option), Pie of pie (second option) or bar of pie (third option).

In the Charts group, click on Pie chart icon (highlighted in the image below).

One of them is Charts group (highlighted in the image below).

When you click Insert, it will display a set of options.

Then with the data selected, click Insert tab.

Highlight all the data including its headers.

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

The excel sheet is a monthly sales data for an online retailer. Here is the data I will use for my demo in this guide. To create a pie chart in Excel you need a set of data.

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

A pie chart is a circular representation of a data set in portions.īy Victor Ashiedu | Updated Aug| 6 minutes read This guide demos how to create a pie chart in Excel and Google Sheets. How to Create a Pie Chart in Google Sheets.

Make a pie chart in excel mobile