Show
Using a pie chart is one of the best ways to present your data visually. Here's how to make one in Google Sheets.
Step 2: Create the Pie ChartNext, highlight the values in the range A1:B7. Then click the Insert tab and then click Chart: The following pie chart will automatically be inserted: Step 3: Customize the Pie ChartTo customize the pie chart, click anywhere on the chart. Then click the three vertical dots in the top right corner of the chart. Then click Edit chart: In the Chart editor panel that appears on the right side of the screen, click the Customize tab to see a variety of options for customizing the chart. First, we can click Pie chart and change the Slice label to Percentage. Next, we can click Pie slice and change the individual colors of the slices in the chart if we’d like: Next, we can click Chart & axis titles and change the Chart title to whatever we’d like: Next, we can click Legend and change the Position to wherever we’d like: The final pie chart looks like this: Additional ResourcesThe following tutorials explain how to create other common charts in Google Sheets: How to Make a Box Plot in Google Sheets How do I make a pie chart with two sets of data in Google Sheets?Create a Chart with Multiple Ranges of Data. Step 1: Format your data into rows and columns so a chart can be created. ... . Step 2: Select the data to be included in the chart, with the headings included.. Step 3: Click Insert in the file menu, then click Chart. ... . Step 4: Format your Newly Created Chart in the Chart Editor.. How do I create a pie chart with categories and percentages in Google Sheets?How to Create a Pie Chart in Google Sheets. Insert data range. The first step is to insert all your data onto Google Sheets. ... . Click Chart. Once you have added your data, click the Insert tab on top. ... . Click Pie Chart on Chart Editor. ... . Select data and your pie chart will appear.. How do I add percentages to a pie chart in Google Sheets?Pie Chart – Show Percentage – Excel & Google Sheets. Add Data Labels. Click on the chart. ... . Change to Percentage. This will show the “Values” of the data labels. ... . Right click on the new labels. Select Format Data Labels.. Uncheck box next to Value. ... . Final Graph with Percentage. ... . Adding Percentages to a Pie Chart In Google Sheets.. |