--- title: "How to make a pie chart in Google Sheets " description: "Create a pie chart in Excel with our step-by-step guide. From preparing data to customizing and sharing charts, check out our tips for clear data visualization." image: "https://images.ctfassets.net/lzny33ho1g45/1d2ScS0XusebtTq7GvoL2T/783a6630bf45516429baa1a4e7ba4711/google-sheets-app-tips.jpg" --- # How to make a pie chart in Google Sheets Create a pie chart in Excel with our step-by-step guide. From preparing data to customizing and sharing charts, check out our tips for clear data visualization. The best pie in the world is the homemade buttermilk apple pie my grandmother baked every Thanksgiving (let me have this one, ok?). I'll never be able to re-create it, but as the saddest consolation ever, I'm really good at making pie _charts_.  Here, I'll guide you through how to make a pie chart in Google Sheets—from entering your data correctly to customizing every slice to fresh-baked perfection. It's no family recipe, but it can turn out almost as pretty.  **Table of contents:** - [How to make a pie chart in Google Sheets](#pie) - [Customize your Google Sheets pie charts](#additional) - [How to export and share a Google Sheets pie chart](#export) - [How to make a pie chart from data in multiple sheets](#how) - [Automate Google Sheets](#automate) ## How to make a pie chart in Google Sheets First, I'll walk you through how to create a simple pie chart. Just the data, no bells and whistles. If you want more details, keep reading. 1. Input your data into a new sheet. 2. Highlight the data range you want included in your pie chart. 3. Click **Insert**, and select **Chart.** 4. If it doesn't automatically create the chart as a pie chart, in the _Chart editor_ panel that appears, select **Pie chart** under _Chart type _in the _Setup _tab. 5. Customize your chart however you want by clicking the **Customize** tab in the _Chart editor. _You can change the labels, colors, and all sorts of other things. 6. To export, click the three dots in the top-right corner of the chart, select **Download**, and choose your file format. If that didn't do the trick, here are a few more specifics. ### 1. Input data into a new sheet The first step is to input your data into Sheets correctly. Data should be in two columns, one for the categories and one for the corresponding values. In this example, our category is _Industry_, and the value is the number of _Participants_ from each industry. (Sheets will automatically turn those into percentages when you make the pie chart.)  ### 2. Select the data range Next, select the **data range.** Click and drag to highlight the range of data you want to include in your chart. Make sure to include all fields—including column headings—you want to include in the chart, not just the numbers.  ### 3. Insert chart Time to wave the pie chart wand. Go to the top menu, and click **Insert > Chart. ** You'll immediately see a chart pop up on top of your sheet. Depending on the data you have, Sheets might guess that you want a pie chart and give it to you right away. If it doesn't, in the _Chart editor_ that appears on the right side, look for the _Chart type _dropdown, and select **Pie chart.**  ### 4. Customize the title Right now, your chart title may be a little vague ("Participants"). To change that, click on the chart, and then go to the **Customize** tab in the Chart editor.  Click **Chart & axis titles **to expand it**.** Under _Title text_, replace the existing title with whatever you want it to say.  Once your title is in place, your basic pie chart is ready to go.  **Note: **If you change the data used in the chart, your pie chart will update to reflect the new data automatically. ## Customize your Google Sheets pie charts Now that you can make a basic pie chart in Google Sheets, you may be ready to shake things up. Dazzle stakeholders with colors, sparkles, and digital glitter glue.  Here are some additional customization options:  - **Chart style: **To change the background color, font, and border color, go to the _Chart editor_.** **Under the _Customize_ tab, expand **Chart style** and adjust the color and font options to your preferences. - **Adjust chart size and layout:** Click on the chart, grab the corners or edges, and drag to expand it for better readability. - **Convert 2D charts to 3D:** In the _Chart editor_, under the _Setup_ tab, select **3D pie chart** to switch from 2D to 3D. - **Customize slice labels: **In the _Chart editor_,** **under the _Setup _tab, expand the **Label** dropdown to choose which field to display next to each slice. - **Customize label font and style: **In the _Chart editor_,** **under the _Customize_ tab, expand **Pie chart** and adjust the _Label font_ and _Label font size_ options to your preferences. - **Change legend position:** In the _Chart editor_, under the _Customize_ tab, expand **Legend**, and select the desired position from the _Position_ dropdown menu. You can choose from Top, Bottom, Left, Right, None, Auto, and Labeled. - **Change slice appearances. **In the _Chart editor_, under _Customize_, expand the **Pie slice** section and choose the slice you want to adjust. You can then change the color of the slice and even separate it from the chart. ## How to export and share a Google Sheets pie chart Unless you plan to beam it into your coworkers' minds, mental telepathy style (valid), it's time to export your Google Sheets pie chart. Click the three dots in the top-right corner of your pie chart.  You'll have the following options: - **Download: **Click **Download chart** and select if you want to export your chart as a PDF, PNG, or SVG. - **Publish: **Click **Publish chart**, and you can either link directly to the chart, or embed the chart's code on the web. - **Copy: **Click **Copy chart**, and the image will be saved to your clipboard. Then, you can paste it elsewhere in that sheet or into a different sheet or document. ## How to make a pie chart from data in multiple sheets So now we know how to make a pie with only one set of ingredients. But what if you have data in multiple sheets? Think of it like doubling the recipe. It's possible, but you'll have to do a little extra work.  1. Ensure all the sheets you want to use in your pie chart have standardized column headers. The datasets you want to combine need identical labeling. 2. Add a third sheet to your doc to consolidate data. In this example, we have a sheet called _Q1_ and a sheet called _Q2_, which we'll combine in a third sheet called _Calculations_**. ** 3. In your new blank sheet, go to the top menu and click **Insert > Chart. **Under the _Chart type _dropdown, select **Pie chart**. 4. In the _Chart editor_, under the _Setup _tab, click the **Select data range** icon (the little grid of four boxes)** **in the _Data range_ section, and click **Add another range** to create fields for each sheet you want to include (two fields for this example). 5. Input the formula `[Sheet name]![Cells:Cells]` for each set of cells you'd like to add, customizing the sheet name and cell range accordingly. In this example, those codes would be `Q1!A1:B6` and `Q2!A1:B6` since the data we want to include from sheets Q1 and Q2 are found in columns A through B and rows 1 through 6. (Be sure to put a single quotation mark around any multi-word sheet names and leave no spaces between any of the other symbols.) Now, data from every sheet you selected will be combined into one pie chart with slices for each line you included (in this case, five from each sheet). If the full dataset isn't populating, you may need to tweak the settings by going to **Setup > Combine ranges** and toggling between _Vertically_ and _Horizontally_. In my case, it was set to horizontal by default, and switching to vertical ensured the data was aggregated from vertical cells in my input data. ## Automate Google Sheets Pie charts help viewers easily digest insights by instantly visualizing trends, patterns, and proportions. It's all the same data you're already working with—just now with a fresh-baked crust.  To get that data into (and out of) Google Sheets easier, [integrate it with Zapier](https://zapier.com/apps/google-sheets/integrations). Then you can connect Google Sheets to thousands of other apps to automate your workflows._ _Zapier can automatically add new rows to your spreadsheets based on activity in other apps, notify teammates when your reports are updated, or send data to other apps when you update a specific sheet. Learn more about [how to automate Google Sheets](https://zapier.com/blog/automate-google-sheets/), or check out these pre-built automations. **Related reading:** - [Google Sheets automation ideas to organize your business](https://zapier.com/blog/automate-google-sheets/) - [How to automate spreadsheets](https://zapier.com/blog/automate-spreadsheets/) - [Google Forms to Google Sheets: How to automatically update inventory](https://zapier.com/blog/manage-inventory-google-forms-sheets/) - [How to connect ChatGPT with Google Sheets](https://zapier.com/blog/connect-google-sheets-with-chatgpt/)