How to Make a Percentage Graph in Google Sheets

Turning a list of numbers into a clear, compelling visual story is a core skill for any marketer or business owner. Percentage graphs are perfect for this, showing how individual parts make up a whole, like which marketing channels drive the most traffic or which products account for the biggest slice of your revenue. This guide will walk you through exactly how to create and customize percentage graphs, like pie charts and stacked bar charts, directly in Google Sheets.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why Use a Graph for Percentages Anyway?

You can just show a table of percentages, so why bother with a graph? It’s all about immediate impact and clarity. Our brains are hardwired to process visual information far faster than text or numbers. A well-designed percentage graph accomplishes a few key things:

• Shows Proportions Instantly: At a glance, anyone can see the biggest and smallest contributors. You don't have to scan a column of numbers, a large slice of a pie chart or a long segment of a bar chart immediately draws the eye.
• Makes Comparisons Easy: It simplifies the comparison between different categories. You can instantly see that "Organic Search" is twice as large as "Paid Social" without doing any mental math.
• Tells a Clear Story: A chart provides a simple narrative. It can highlight a dominant channel, reveal an area for improvement, or show a balanced distribution across categories. It turns raw data into a talking point.

Basically, a good graph saves your audience from having to interpret your data, it does the heavy lifting for them, making your reports more effective and your insights more memorable.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 1: Get Your Data Ready

Before you can make a beautiful chart, you need clean and organized data. A great graph always starts with a well-structured table. For a percentage graph, you typically need two columns:

1. Categories: The labels for each slice or segment (e.g., Traffic Source, Product Name, Sales Rep).
2. Values: The raw numbers associated with each category (e.g., Website Sessions, Units Sold, Revenue).

Let's use a common marketing example: analyzing website traffic sources for a month. Your initial data might look like this:

Column A: Traffic Source

Column B: Sessions

Once your columns are formatted, you’re ready to start visualizing. Your sheet would look something like this:

Calculating the Percentages

While some Google Sheets charts can work with raw numbers to show proportions, it's often best practice to calculate the actual percentages first. This gives you more control and ensures your labels are accurate.

Here’s how to do it:

1. First, you need the total of all your values. Click on an empty cell below your 'Sessions' column (in this example, B7) and type the formula:

=SUM(B2:B6)

This will give you the total number of sessions.

1. Now, in a new column (Column C), we'll calculate the percentage for each source. In cell C2, type the following formula:

=B2/$B$7

Let's break that down:

• =B2 refers to the sessions for "Organic Search."
• / means divide.
• $B$7 refers to an absolute reference. Normally, if you dragged the formula down, B7 would change to B8, B9, etc. The dollar signs $ lock the reference to the 'Total' cell, so every category is divided by the same total.

1. Hit Enter. You'll see a decimal value. Now, click on cell C2, and click the small blue square (the fill handle) in the bottom-right corner. Drag it down to cell C6 to apply the formula to all your traffic sources.
2. Finally, with the percentage cells (C2:C6) still selected, go to the toolbar and click the Percent format (%) button. This will format your decimals into clean percentages.

Your data set should now look perfectly prepped for chart creation:

Step 2: Create a Pie Chart to Show Parts of a Whole

The pie chart is the quintessential graph for showing percentages. It’s immediately intuitive because it represents a complete circle (100%), with each slice representing a category’s portion.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Make a Basic Pie Chart

1. Select Your Data: Click and drag to highlight the cells containing your categories and your new percentages. In our example, you would select A1:A6 and then hold Ctrl (or Cmd on Macs) and select C1:C6 so both non-adjacent columns are selected. This ensures Google Sheets knows what to label each slice of the pie.
2. Insert the Chart: Go to the menu bar up top and click Insert > Chart.
3. Choose Your Chart Type: Google Sheets is pretty smart and will often default to a pie chart based on your data. If it doesn’t, a 'Chart editor' sidebar will appear on the right. Under the Setup tab, find the 'Chart type' dropdown and select 'Pie chart'. You can also choose a 'Donut chart' for a more modern look, or a '3D pie chart' if you prefer that style.

And just like that, you have a basic pie chart!

Customizing Your Pie Chart for Clarity and Impact

A default chart is good, but a customized chart is great. The 'Chart editor' is your control center for making your graph clear and visually appealing.

Under the Customize tab in the Chart editor, here are the most important settings to adjust:

• Chart Style: Change the background color, font, and border of your chart. A subtle background or a consistent brand font can make a big difference in a report.
• Pie Chart:
• Chart & axis titles: Always give your chart a descriptive title. 'Chart' is not helpful. Something like "Website Traffic Sources - Q3 2024" tells the reader exactly what they're looking at. Click on the title text directly on the chart to edit it.
• Series: Here, you can change the color of individual slices. This is useful for matching your company's brand colors or for highlighting a specific category (e.g., making your most important channel a bold, distinct color).
• Legend: Adjust the legend's position (Top, Bottom, Left, Right) or remove it completely if labels on slices are better for your chart. Having labels on each slice and a legend is usually redundant. You have the option to adjust fonts and formatting here too.

Step 3: Using a 100% Stacked Bar Chart

What if you have too many categories? A pie chart can look cluttered and become hard to read with more than 5-6 slices. That’s when the 100% stacked bar chart (or column chart) comes in handy.

This chart type displays your data as a single bar that totals 100%, with colored segments representing the percentage contribution of each category. It’s a great alternative to the pie chart, especially when comparing compositions across different time periods (though for this simple guide, we're focusing on a single set of percentages).

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

How to Make a Stacked Bar Chart

1. Select Your Data: Just like before, highlight your category names and percentage values (A1:A6 and C1:C6).
2. Insert Chart: Go to Insert > Chart.
3. Choose Your Chart Type: Google Sheets might default to a column chart. In the 'Chart editor,' go to 'Chart type' and scroll down to the 'Bar' or 'Column' section. Select either the '100% stacked bar chart' or '100% stacked column chart'.
4. Since we are not comparing multiple data series here, you will also need to click 'Switch rows, columns' and also check 'Use column A as headers'.

And you're done. Just like with the pie chart, use the "Customize" tab in the chart editor to add a clear title, adjust colors, and most importantly, add data labels. Go to Series > Data labels to display the exact percentages on each segment, which makes the chart much easier to interpret.

Final Thoughts

Creating percentage graphs in Google Sheets is a straightforward process that can dramatically improve how you communicate data. By preparing your data correctly and using the customization options, you can move beyond basic charts and create insightful visuals that tell a clear story, whether you choose a classic pie chart or a modern stacked bar chart.

While mastering these tools is valuable, the process of pulling data from different marketing and sales platforms, cleaning it up in spreadsheets, and manually building reports every week can quickly eat up your time. At Graphed, we automate this entire process. You can connect all your data sources like Google Analytics, Shopify, and social media ads in a few clicks, and then create real-time dashboards and reports just by describing what you want in plain English. It saves you the hours of manual work so you can focus on the insights, not the spreadsheet wrestling.