How to Show Percentage in Bar Chart in Google Sheets

Showing raw numbers in a bar chart can be useful, but adding percentages provides a layer of context that makes your data instantly more understandable. Instead of leaving your audience to do the mental math, you can show them exactly what proportion each bar represents. This article will walk you through how to prepare your data and two effective methods for displaying percentages in a bar chart right within Google Sheets.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why You Should Show Percentages in Your Bar Charts

Before we jump into the "how," let's quickly cover the "why." Adding percentages to your charts isn't just about adding more numbers, it's about telling a clearer story with your data. Here are a few key reasons it's so effective:

• Provides Immediate Context: A value of "2,150 clicks" is just a number. But seeing "2,150 clicks (43%)" immediately tells you that this single channel drives nearly half of your engagement, offering a much more powerful insight.
• Simplifies Comparisons: Percentages share a common scale (0 to 100), making it incredibly easy to compare different categories. It’s easier to grasp the difference between 15% and 55% than between 750 and 2,750, especially when you have many bars on the chart.
• Highlights Distribution: Percentages excel at showing how a whole is divided among its parts. This is perfect for visualizing things like survey results, budget allocation, or sources of website traffic.

Step 1: Preparing Your Data for Percentages

You can't create a percentage-based chart without first calculating the percentages. This is the most important step, as a well-structured data table makes the charting process smooth and simple. Let's use an example of website traffic sources for a month.

Imagine your raw data looks like this:

To get this ready for a percentage chart, you need to add a "Percentage" column.

Graphed

Still Building Reports Manually?

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

Watch the Demo

1. Calculate the Total

First, you need the grand total of all your values. The easiest way is to use the SUM() function. Click on an empty cell below your session data (in our example, B7) and type:

=SUM(B2:B6)

This will give you the total number of sessions. Keep this number handy.

2. Create the Formula for the Percentage Column

Now, create a new column named "Percentage." In the first cell of this column (C2), we'll write a formula to divide the sessions for that source by the grand total.

The key here is to use an absolute reference for the total cell. By putting dollar signs $ before the column letter and row number ($B$7), you "lock" that part of the formula. This ensures that when you drag the formula down, it will always divide by the correct total.

In cell C2, type the following formula:

=B2/$B$7

3. Drag the Formula Down and Format

Press Enter. You'll likely see a decimal number like 0.43. Now, click the small blue square in the corner of cell C2 and drag it down to the last row of your data. The formula will automatically populate for each traffic source.

To turn these decimals into clean percentages, select the entire "Percentage" column (C2:C6), then go to the toolbar and click the Percent format (%) button.

With your data correctly formatted, you’re now ready to create the chart.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 1: Displaying Percentage Labels Directly on the Bars

This is the simplest method, ideal for charts where the percentage is the most important value you want to display.

Step-by-Step Instructions

1. Select the data you want to chart. For this method, you only need the categories and the percentages. Highlight the "Traffic Source" column and the "Percentage" column (hold down Ctrl or Command to select non-adjacent columns).
2. Go to the menu and click Insert > Chart. Google Sheets will likely create a pie chart by default.
3. In the Chart editor on the right, change the "Chart type" to a Bar chart or Column chart (they're functionally the same, just oriented differently).
4. Now, to add the percentage labels, click the Customize tab in the Chart editor.
5. Expand the Series section.
6. Scroll down and check the box next to Data labels. The percentages will instantly appear on each bar of your chart. You can adjust the font, position, and color of the labels here as well.

That's it! You now have a clean bar chart that clearly labels each category's contribution as a percentage.

Method 2: Showing Both Raw Numbers and Percentages

If you want to show both the raw count and the percentage for ultimate context, Google Sheets doesn't have a direct "Show both" option for labels, but we can work around it by creating a custom label in our spreadsheet.

Step 1: Create a Custom Label Column

Go back to your data table. Add a new column called "Custom Label." In this column, we're going to use a formula to combine the session count and the percentage into a single text string. We'll use the TEXT() function to ensure our percentage keeps its formatting.

In cell D2, type this formula:

=B2 & " (" & TEXT(C2, "0.0%") & ")"

Let's break that down:

• B2 &: Takes the value from the Sessions column (our raw number) and prepares to join it with text.
• " (" &: Adds a space and an opening parenthesis.
• TEXT(C2, "0.0%"): This is the important trick. It takes the percentage value from C2 and converts it into a formatted text string. Without this, you'd just get the raw decimal (like 0.43).
• & ")": Adds the closing parenthesis.

Drag this formula down the column, just like before. Your table should now look like this:

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Create the Chart and Apply the Custom Labels

1. Create a new chart. This time, select the Traffic Source and Sessions columns (our raw data). Go to Insert > Chart and select a bar chart.
2. In the Chart editor > Customize > Series, check the box for Data labels. Initially, you'll just see the raw session numbers on your bars.
3. Go back to the Setup tab in the Chart Editor.
4. Find the "Series" section for your Sessions data. Click the three vertical dots icon and choose Add labels.
5. A dialog box will appear asking you to "Select a data range." Click into this box and then select your entire "Custom Label" column (D2:D6). Click OK.

The chart will instantly update, replacing the default raw number labels with your new, combined labels. You now have a professional-looking chart that provides two layers of information in one clean view.

Final Thoughts

Whether you need a simple visual or a detailed breakdown, showing percentages on your bar charts in Google Sheets is a powerful way to add clarity and impact. By first preparing your data with a percentage column, you can use the standard data label option for a quick percentage chart or create a custom label column with the TEXT formula to display even more context.

Creating charts like this involves a few manual steps - calculating totals, building formulas, and customizing chart settings. At Graphed, we built a tool to eliminate this kind of busy work. Instead of spending time in spreadsheets, you can connect your data sources like Google Analytics and simply ask, "create a bar chart showing website sessions by source with percentages for last month." We instantly generate the dashboard for you, connected to your live data, so you can spend less time wrangling formulas and more time acting on the insights.