How to Make Bar Chart Thicker in Excel

Nothing ruins a good Excel chart faster than skinny, hard-to-read bars that get lost in a sea of white space. Bar charts are meant to provide an immediate visual summary, but if the bars themselves lack presence, your entire message can fall flat. This guide will show you exactly how to make your bar charts thicker in Excel, giving your data the bold, clear presentation it deserves.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Why Thicker Bars Are Better for Data Visualization

Changing the thickness of the bars in your chart isn’t just a stylistic preference, it’s a critical element of effective data visualization. The default settings in Excel often produce bars that are too thin, creating several issues that can undermine the clarity of your report or presentation.

Improving Readability

The most immediate benefit of thicker bars is improved readability. Thin bars force your audience to squint and focus harder just to see the data, increasing the time it takes for them to process the information. When bars have more visual weight, they are easier to distinguish, compare, and understand at a glance. For viewers seeing your chart from a distance – or for anyone moving quickly through a report – bold, thick bars ensure your data points aren’t missed.

Professional Aesthetics and Visual Impact

Aesthetics matter in professional reporting. Charts with flimsy, narrow bars can look cheap or unfinished. In contrast, well-proportioned, substantial bars give a chart a polished, confident, and professional feel. It signals that thought has been put into the design and presentation of the data, which in turn builds trust and confidence in your analysis. Thick bars fill the chart area more effectively, creating a balanced visual that is more pleasing to the eye.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Reducing Cognitive Load

Cognitive load refers to the amount of mental effort required to understand information. When a chart is filled with too much empty space and the core data elements (the bars) are thin, the viewer’s brain has to work harder to connect the labels on the axes to the ends of the bars. Thicker bars reduce this empty space, making the connection between the bar and its value more obvious. This streamlined visual pathway reduces cognitive load, allowing your audience to absorb the insights from your data faster and with less effort.

How to Make Bar Charts Thicker: The Core Method

The secret to controlling bar thickness in Excel lies within the "Format Data Series" options. Specifically, two settings determine how your bars appear: Gap Width and Series Overlap. For 99% of cases, adjusting the Gap Width is all you need to do.

• Gap Width: This setting controls the amount of empty space between each category of bars. Excel’s default is often high (around 150% or even 219%), which creates a lot of space and results in thin bars. To make bars thicker, you need to decrease the Gap Width percentage. A smaller percentage means less space between bars, which forces the bars themselves to become wider to fill the area.
• Series Overlap: This setting only applies to grouped bar charts (where you have multiple bars per category, like "Q1 Sales" and "Q1 Profit"). It controls the spacing or overlap of bars within the same category. We will touch on this later, but for a simple bar chart, you can ignore this setting entirely.

A Detailed, Step-by-Step Guide to Adjusting Bar Thickness

Ready to transform your chart? Let's walk through the exact steps. The process is incredibly simple once you know where to look. Let's assume you have already created a basic bar chart.

Step 1: Right-Click a Bar to Select the Data Series

Start by clicking once on any of the bars in your chart. When you do this, you'll see small circles or squares appear at the corners of all the bars. This indicates that you've selected the entire data series, not just a single, individual bar. Selecting the whole series is crucial for applying the change uniformly across your chart.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 2: Open the 'Format Data Series' Pane

With the data series selected, right-click your mouse. A context menu will pop up. At the bottom of this menu, click on "Format Data Series..."

This will open a new pane on the right side of your Excel window packed with formatting options.

Step 3: Locate and Adjust the 'Gap Width' Setting

In the "Format Data Series" pane, make sure you are on the "Series Options" tab, which is represented by a small bar chart icon. Within this tab, you will find the "Series Options" section with sliders for 'Series Overlap' and 'Gap Width'.

Focus on the Gap Width slider. By default, it might be set to something like 150%. This percentage represents the width of the gap relative to the width of a single bar. In other words, a 150% gap width means the space between your bars is 1.5 times the width of one of the bars.

To make the bars thicker, you need to reduce this number. You can either drag the slider to the left or type a new, smaller number directly into the box.

• A Gap Width of 100% means the gap is exactly the same width as one bar.
• A Gap Width of 50% makes the gap half the width of a bar, resulting in much thicker bars.
• A Gap Width of 0% removes the gap entirely, so the bars will touch each other. This is often used for creating histograms.

As you adjust the percentage, you'll see your chart update in real-time. A good, balanced starting point for most charts is between 50% and 80%. This creates substantial, easy-to-read bars without making the chart feel too crowded.

Adjusting Thickness in Different Chart Types

While the Gap Width adjustment works universally, its interaction with Series Overlap changes slightly depending on your chart type.

For Grouped Bar Charts

In a grouped bar chart, you're not just comparing categories, but also sub-series within those categories (e.g., comparing product sales in different regions for Q1). Here, both settings become useful.

• Gap Width: This still controls the empty space between the different groups of bars (e.g., the space between the Q1 cluster and a Q2 cluster). Lowering it will widen the entire cluster of bars.
• Series Overlap: This now controls the arrangement of bars within a single cluster. It takes a percentage that can be positive or negative.

For a clean look on a grouped chart, try setting Gap Width to around 100% and Series Overlap to a small negative number like -10% or -15%. This creates visually distinct clusters that are easy to interpret.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

For Stacked Bar Charts

With a stacked bar chart, things get even simpler. Since all the series are already stacked on top of one another within a single bar column, the Series Overlap setting has no visual effect. The only setting you need to worry about is Gap Width, which works exactly as it does for a simple bar chart. Just lower the percentage to reduce the space between the stacked bars and make them wider.

Troubleshooting Common Issues

Sometimes you might run into a couple of hiccups. Here's how to solve the most common ones.

• "I only thickened a single bar, not all of them!"
• "My bars are too thick and my labels are overlapping!"
• "The 'Format Data Series' options are grayed out."

Final Thoughts

Adjusting the thickness of your bars is a small change that delivers a huge improvement in your Excel charts. By simply right-clicking a data series and lowering the 'Gap Width' in the 'Format Data Series' pane, you can make your visuals clearer, more professional, and far more impactful. This easy fix turns a weak, default chart into a strong, compelling piece of data storytelling.

While mastering formatting in spreadsheets is a valuable skill, the process of repeatedly tweaking charts can drain hours from your week. We created Graphed to automate that entire manual workflow. After connecting your data sources like Google Analytics or Salesforce, you can create real-time dashboards just by asking questions in plain English. There’s no need to format anything manually, you simply describe the report you need, and the charts are built for you in seconds, letting you focus on strategy instead of report-building.