Step 1: Open the sheet

First, open the sheet of the Google Sheets file that contains the data you want to represent with a pie chart.

Step 2: Select the dataset

Click and drag to select the dataset that you want to include in your pie chart. Make sure to select both the categories and the values.

Step 3: Open the chart editor

Once you've selected the data you want to include in the chart, click on the "Insert" at the top of the screen. In the drop-down menu, choose "Chart" to access Google Sheets’ chart editor. It will open as a sidebar on the right side of your screen.

Step 4: Choose to create a pie chart

In the Chart Editor, select "Pie chart" from the list of chart types. This will allow you to customize your chart as desired, including adding labels and a title.

Step 5: Move the pie chart to its own sheet (optional)

If you want to edit your pie chart without distractions, you can move it to another sheet. To do so, click on the three vertical dots at the top right of the chart and select “move to own sheet.” Google Sheets will automatically create a new sheet called “Chart 1,” where you can view and edit your pie chart.

Step 6: Customize the chart

The Chart Editor allows you to customize various aspects of your pie chart. You can access it by clicking on the “Edit chart” button in the pie chart’s menu.

Step 6.1: Change the chart’s title

In the chart editor, under "Chart & axis titles," select “Chart Title” in the dropdown list. There, you can type a new title and choose your preferred font, size, format, and text color, to make your chart more visually appealing.

Step 6.2: Change each pie slice’s appearance

Still in the Chart Editor, under "Pie slice," you can change the appearance of your pie chart’s individual slices.

For example, if you want people to pay attention to one particular pie slice, you can make the respective slice have a more distinct color and by increasing the distance from the center of the chart.

Step 6.3: Include data labels

To add labels to your pie chart slices, head to the chart editor and navigate to the "Pie chart" section. There, you can opt to display category names, percentages, or both. You can also tweak the font size and style to your liking.

Step 7: Preview your changes, then share

To preview your newly-customized pie chart, simply close the chat editor and your chart will appear in full screen. If you're satisfied with it, you can share it using the "Share" button, publish the chart, and download it as an image.

Step 1: Log in to Softr or create an account

First, you will need to login to Softr. If you don’t have an account, you can sign up to Softr for free.

Step 2: Click on “New Application”

Softr offers a wide variety of templates that can simplify the process of creating apps with data stored in Google Sheets. To access these templates, click on “New Application".

Step 3: Create a blank application

Because you want to make something as simple as a pie chart, click on the button to create a blank application.

Step 4: Select prebuilt pages

Again, because all you need is a page to create a pie chart, deselect all pages, except the Home. Then click on “Create application.”

Step 5: Connect Softr and Google Sheets

To create your pie chart in Softr using your Google Sheets data, you'll first need to connect these two products.

Step 5.1 Choose Google Sheets as the data source

Now, you need to allow Softr to access your data in Google Sheets so that you can then create a pie chart based on it. To do so, click on “Google Sheets” and then on “Continue.”

Step 5.2: Log in to your Google account

Now you need to specify in which Google account your Google Sheets file is in. You can do so by logging in to that Google account.

Step 5.3: Authorize Softr

Next, authorize Softr to make changes in your Google Sheets and Google Drive files, by ticking the two boxes highlighted in the image below. Then click on “Continue.”

Step 6: Delete all blocks

Before you create your pie chart, hover on each prebuilt block and delete all of them, so that you end with a blank canvas in which you can start building.

Step 7: Access the list of premade blocks

Softr offers a wide list of premade blocks, including pie charts. To access them, click on the “+” sign at the top right corner of your screen or on the “Add your first block” button.

Step 8: Choose to create a pie chart

Once the block menu slides in, type “pie chart” and click on the respective block to select it.

Note that, although you can’t use the pie chart on the free version, you can use it once you activate the 30-day trial version. You won’t get charged until after 30 days, so you can cancel your subscription at any time.

Step 9: Choose from which Google Sheet file you want to import the data

Head over to the Source tab and locate the “Connect data source” button. Click on it and choose your connected Google Sheets account. From there, you’ll be presented with a list of Google Sheets files to choose from. Once you’ve found the one with the data you need, select it and then choose the specific sheet you want to import data from.

Step 10: Customize your pie chart

To customize your pie chart, click on the Features tab to make the desired changes.

Step 10.1: Change the title and subtitle

Type the title and subtitle you want into the text box under the respective heading.

Step 10.2: Update metrics

To ensure the data from your connected Google Sheets displays through the pie chart, go to the metrics section just below the title and subtitle.

In the chart block settings, choose the aggregate function “Sum,” and for the field, select your main value (Organic Traffic, in our case). Under Groupings, select the field in which you want your metric to be grouped (Year, in our case).

Step 10.3: Change the styling

You can change the background color and add border lines to the top and bottom of your chart using the “styles” bar.

Step 10.4: Change the access permissions

To update the access permissions, go to the Visibility tab. The default setting there is “All users,” which means everyone can see the chart when it is published, whether they are logged in or not.

If you want only logged-in users to access the data, click on the dropdown and select “Logged-in users.” Alternatively, if you want non-logged-in users alone to view the pie chart, select “Non-logged-in users.”

Step 11: Test and optimize

Click on the “Preview” button to see how the pie chart looks before sharing it with others.

Step 12: Share your pie chart

Once you’ve finished tinkering with your pie chart, you can now click on the “Publish” button to save all the changes and share it with others.