How to Change the Width of Bars in Excel Charts

Ever created a bar chart in Excel and found the bars looking weirdly spindly or uncomfortably chunky? You're not alone. Adjusting the width of bars is one of the most common formatting tasks, and it's essential for making your data look clear, professional, and easy to understand. This guide will walk you through exactly how to take control of your bar widths using two simple settings.

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 Bar Width Even Matters

The width of your bars might seem like a small detail, but it has a big impact on how your audience interprets your data. It's all about visual balance and readability.

• Bars that are too thin can make the data look insignificant. They get lost in the surrounding white space, forcing your audience to squint to see the values. This can weaken the impact of your message.
• Bars that are too thick can create a cluttered, heavy feeling. They can merge, making it difficult to distinguish between different categories and making the whole chart feel overwhelming.

The sweet spot is somewhere in the middle - a width that gives your data presence without crowding the chart. Getting this right takes your chart from looking like an amateurish default to a polished, professional visualization that tells a clear story.

The Two Secret Settings: Gap Width and Series Overlap

To change the width of bars in Excel, you don’t actually click a "bar width" button. Instead, you control the space around the bars. There are two key settings hidden in the "Format Data Series" pane that you need to know: Gap Width and Series Overlap.

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

Understanding Gap Width

Gap Width controls the amount of empty space between each category of bars. Think of a simple column chart showing sales by quarter. The Gap Width setting manages the white space between the Q1 bar, the Q2 bar, the Q3 bar, and the Q4 bar.

Here’s the most important thing to remember: Gap Width has an inverse relationship with bar width.

• Decreasing the Gap Width percentage increases the width of your bars.
• Increasing the Gap Width percentage decreases the width of your bars.

It's a bit counterintuitive at first. Don't think of it as "bar width." Think of it as "space between bars." When you make the space smaller, the bars get wider to fill the available room.

The Gap Width is set as a percentage of the bar's width. A value of 150% (a common Excel default) means the space between categories is 1.5 times the width of a single bar. Bringing that down to 50% means the space is only half the width of a bar, which makes the bars themselves much wider.

Understanding Series Overlap

Series Overlap comes into play when you have a clustered bar or column chart - one with multiple data series. Imagine comparing sales for 2023 and 2024 for each quarter. In this case, each quarter (the category) would have two bars (one for each series: 2023 and 2024).

Series Overlap controls how those two bars within a single category are positioned relative to each other.

• A negative percentage creates a gap between the bars within a category. For example, -20% will put a small space between the 2023 and 2024 bars. This is often used for clarity.
• Zero percent (0%) makes the bars in the cluster touch edges.
• A positive percentage makes the bars overlap. For example, +50% would make the second bar cover half of the first bar. This is less common but can be used for specific styling effects.

To summarize the difference:

• Gap Width: Manages the space between different groups of bars (e.g., between Q1 and Q2).
• Series Overlap: Manages the space or overlap within a single group of bars (e.g., between the 2023 and 2024 bars inside Q1).

Step-by-Step: How to Change Bar Width in Excel

Now that you understand the concepts, let's put them into practice. The process is very similar for column charts (vertical bars) and bar charts (horizontal bars).

For Charts with a Single Data Series

Let's start with a basic chart, like monthly website traffic, where you only have one set of bars.

1. Start with your created chart in Excel.
2. Right-click on any one of the bars in your chart. A context menu will appear.
3. From this menu, select Format Data Series.... This will open a settings pane, usually on the right side of your screen.
4. In the "Format Data Series" pane, look for the "Series Options" tab. It’s typically represented by a small icon of a bar chart.
5. Here, you will find the Gap Width slider and input box.

Now you can make your adjustment. To make your bars wider, you need to decrease the gap width. Try sliding the bar to the left or just typing a smaller number into the box. For example, if the default is 219%, try changing it to 80%. You’ll see the bars get wider and more prominent immediately.

Play around with this value until you achieve the visual balance you're looking for. There's no single "correct" number - it depends entirely on a chart's dimensions and how many data points it displays.

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

For Clustered Charts with Multiple Data Series

Now, let's tackle a clustered chart where you might be comparing two or more sets of data, like online ad spend vs. social media ad spend per month.

1. Just as before, right-click on any bar from any data series in your chart.
2. Select Format Data Series... to open the pane.
3. Under the "Series Options" tab, you'll now see controls for both Series Overlap and Gap Width.

Adjusting the Overall Bar Width First

It's usually best to start with the Gap Width. This setting will affect the entire group of bars for each category. Just like in the previous example, decrease the Gap Width percentage to make all the bars in your chart (both online ads and social media ads) collectively wider and reduce the space between months.

Adjusting the Spacing Within a Cluster

Next, use the Series Overlap slider to fine-tune the space between the online ad and social media ad bars within each month.

• The default is often 0%, meaning the bars touch. This can sometimes look a bit crowded.
• Try setting the overlap to a negative number, like -10% or -25%. This will introduce a delicate but clear gap between the bars within each cluster, making the chart easier to read.

Quick Tips for Polished Bar Charts

Here are a few extra pointers to help you get the most out of your chart formatting.

1. Aim for a Gap Width Around 50% - 150%

While an exact value depends on your data, a gap width between 50% and 150% is a great starting point for most charts. A popular design principle suggests making the gap roughly half the width of a bar, which corresponds to a gap width of 50%.

2. Create a Histogram Look

If you need to create a histogram where columns are flush against each other to show a continuous distribution, you can do so easily. Simply set the Gap Width to 0%. This will remove all space between the categories, making the bars touch.

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

3. Consistency Is Key

If you are creating multiple charts for a single report or presentation, try to use consistent Gap Width values across all of them. This creates a more professional and visually cohesive look, making your entire report feel more polished.

4. Use the F4 Shortcut

If your chart has multiple series and you want to apply the same format to all of them, there's a handy shortcut. After you've formatted your first data series (e.g., set the bar color), you can click on a bar from the second data series and press F4 on your keyboard. This will repeat your last formatting action, saving you several clicks.

Final Thoughts

Mastering the Gap Width and Series Overlap settings may seem small, but it's a fundamental skill for transforming cluttered default charts into clear, impactful data stories. With just a few clicks, you can control the entire feel of your visualization, ensuring your data is presented exactly the way you intend.

Of course, manually perfecting charts in Excel is just one part of the reporting battle. All the time you spend downloading CSVs, wrangling data, and fiddling with formatting sliders is time you aren't spending on strategy. This is exactly the reason we built Graphed. We wanted to eliminate the manual, repetitive busywork of reporting. Instead of building charts click-by-click, you can just connect your data sources and ask questions in plain English - like "Show me a bar chart of Shopify revenue by marketing channel last month" - and instantly get a live, perfectly formatted dashboard that updates automatically. All the beautiful charts, none of the formatting headaches.