How to Show Values on Bar Chart in Google Sheets

Showing the actual values on your bar chart in Google Sheets is one of the quickest ways to make your data understandable at a glance. Instead of forcing your audience to guess a bar's value based on the axis lines, you can put the number right there on the bar itself. This article will walk you through exactly how to add and customize these value labels, step by step.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Setting Up Your Data and Creating a Basic Bar Chart

First things first, you need a chart to work with. Let's start with a simple dataset and turn it into a bar chart. If you already have your chart ready, you can skip ahead to the next section.

Imagine you just finished analyzing Q3 blog performance and want to visualize the number of new articles published by each category.

Your data in Google Sheets would look something like this:

• Column A: Category (e.g., SEO, Email Marketing, Social Media)
• Column B: New Articles Q3

Here’s the setup:

To create the bar chart:

1. Select your data range. Click cell A1, hold down the Shift key, and click cell B6. This will highlight all of your headers and data.
2. Insert the chart. Go to the menu and click Insert > Chart.

Google Sheets is pretty smart and will usually default to a useful chart type. In this case, it will likely give you a column chart. For this guide, let's switch it to a bar chart, where the bars run horizontally. In the Chart editor on the right, under the Setup tab, find "Chart type" and select "Bar chart" from the dropdown menu.

You'll end up with a clean, but basic, bar chart. It’s a good start, but someone has to squint and trace back to the x-axis to estimate the exact number of articles. Let's fix that.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

How to Show Values on a Bar Chart in Google Sheets

This is where the magic happens. Adding the values, or "data labels," is just a few clicks away.

Step 1: Open the Chart Editor If you've just created the chart, the Chart editor sidebar will already be open. If not, just double-click anywhere on your chart to open it.

Step 2: Navigate to the Customize Tab At the top of the Chart editor sidebar, click on the "Customize" tab. This is where you can change everything about your chart's appearance.

Step 3: Go to the "Series" Section Scroll down the options in the "Customize" tab and click on "Series." The 'series' refers to the data being plotted - in our case, the "New Articles Q3" values that make up the bars.

Step 4: Check the "Data labels" Box Within the "Series" dropdown, you'll see a list of formatting options. Simply find the checkbox labeled "Data labels" and click it. Instantly, the numeric value for each bar will appear on your chart!

That’s the core process. You’ve successfully added values to your bar chart. Now, let’s explore how to make those labels look even better and fit your specific needs.

Customizing Your Data Labels for Readability

Just displaying the number is often not enough. Sometimes the labels are too big, the wrong color, or in an awkward position. Google Sheets gives you full control to fine-tune them.

All these options are located in the same Customize > Series panel, right under the "Data labels" checkbox you just clicked.

Changing Data Label Position

The placement of your label can dramatically improve your chart's clarity. You’ll see a dropdown menu for "Position." Here’s what the options do:

• Center: Places the label in the middle of the bar. This looks clean when you have long bars and good color contrast.
• Inside end: Puts the label at the very end of the bar, but still inside of it. This is a very common and professional-looking choice.
• Inside base: Puts the label at the beginning of the bar, near the y-axis.
• Outside end: Places the label just outside the bar. This is incredibly useful when bars are different colors or have dark fills, as it keeps the numbers on the clean white background of the chart. For our example, this is a great choice.

Experiment with these to see which one works best for your specific chart.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Formatting Label Fonts and Colors

Below the "Position" dropdown, you'll find formatting tools for your labels:

• Data label font: Change the font style (e.g., Arial, Roboto, etc.).
• Data label font size: Adjust the text size. If your labels look cramped or too large, slimming them down a little can help. A size of 10 or 12px is often a safe bet.
• Data label text format: Make your labels Bold or Italic. Bolding can help them stand out.
• Data label text color: This is critical for readability. If your bars are dark blue, a white data label placed "Inside end" will pop. If your labels are positioned "Outside end," black or a dark gray usually works best.

Adjusting the Number Format

What if your data involves money, percentages, or ugly long decimal points? You can clean this up directly in the chart editor without having to change your original data.

Further down in the Customize > Series menu, you'll find a "Number format" option. Clicking this allows you to format the labels just like you'd format a cell:

• For currency: Select a currency format like "Accounting" or "Currency" to add dollar signs automatically.
• For percentages: Choose "Percent" to convert a value like 0.85 into 85%.
• To reduce decimals: If you have values like 15.8274, you can choose "Number" and then specify zero, one, or two decimal places to clean up the look.

Adding Labels to Stacked Bar Charts

Stacked bar charts present a unique challenge. Do you want to label each individual segment, or do you want to show the total for the entire stacked bar? Google Sheets handles both scenarios.

Let’s say our data now includes article counts for two quarters, Q2 and Q3:

If you create a stacked bar chart with this data (select the data and in the Chart editor > Setup tab, choose "Stacked bar chart"), you'll have bars with two colored segments.

To add labels, go back to Customize > Series. The process is the same - just check the "Data labels" box.

But for a stacked chart, a new option may appear (depending on your stacking): "Total data labels."

• Checking "Data labels" will add a value to each individual color segment of the bar. For the "SEO" category, this would show "12" on the Q2 segment and "15" on the Q3 segment.
• Checking "Total data labels" adds a single label at the end of the entire stack, showing the sum. For "SEO," it would display "27" at the end of the full bar.

This is extremely useful. Showing individual labels is great for part-to-whole analysis, while the total label is perfect when you care most about the combined performance.

Common Problems and Quick Solutions

Sometimes things don't go as planned. Here are a few common issues and how to fix them in seconds.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Problem: My labels are overlapping or look cluttered.

Solution: You have a few options.

1. Decrease the font size. Go to Customize > Series > Data label font size and make it smaller.
2. Change the label position. Try moving the labels to "Outside end" to give them more breathing room.
3. Increase the chart size. Simply click on your chart and drag one of the corners to make it larger. This will give the bars more space and de-clutter the labels.

Problem: I have a chart with multiple series (e.g., Q2 and Q3 data side-by-side) and want to apply labels to only one of them.

Solution: At the top of the Customize > Series menu, you'll see a dropdown that says "Apply to all series." You can click this and select a specific series (e.g., "New Articles Q3") to format. Once a specific series is selected, checking "Data labels" will only apply them to that dataset.

Problem: The number format on my labels is wrong (e.g., no dollar sign, too many decimals).

Solution: Scroll down in the Customize > Series panel to the "Number format" section. From here you can apply the correct formatting (Currency, Percent, Number with custom decimal places, etc.) without having to change your source data.

Final Thoughts

Adding data labels to bar charts in Google Sheets is a simple but powerful technique to make your information more immediate and impactful. By using the Customize > Series menu, you have complete control over showing, positioning, and styling your values to ensure your charts are as clear and professional as possible.

Making clear, insightful charts in seconds is exactly what we focus on at Graphed. If you find yourself constantly building reports and dashboards from sources like Google Analytics, Shopify, or Salesforce, you can use our platform to do it automatically. Instead of clicking through menus, you can just ask in plain English - "create a dashboard showing sales vs ad spend for the last 30 days" - and our AI builds an interactive, real-time dashboard for you.