How to Add Space Between Columns in Excel Chart

A crowded column chart in Excel can be hard to read, making it difficult for your audience to grasp the insights you're trying to share. Adding a bit of white space between your columns is a small tweak that instantly makes your charts cleaner, more professional, and easier to understand. This guide will show you exactly how to control the spacing in your Excel charts using Gap Width and Series Overlap.

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 Does Column Spacing Matter?

Before jumping into the steps, it’s worth understanding why this simple adjustment is so impactful. Properly spacing your columns does more than just make a chart look better, it actively improves how people interpret your data.

• Improves Readability: White space acts as a visual break, helping the viewer's eye distinguish between different data categories without feeling overwhelmed. It reduces clutter and makes your chart feel less chaotic.
• Emphasizes Data Groups: By controlling the gap, you can visually group related bars or series together, making comparisons more intuitive. This is particularly useful in clustered column charts.
• Creates a Professional Look: A well-formatted chart signals attention to detail. Default Excel settings often result in bulky columns that look clunky. A quick adjustment lends a polished, custom feel to your reports.

The Primary Method: Adjusting a Chart’s Gap Width

The main tool for controlling the space between categories in an Excel chart is the Gap Width setting. Think of a category as a group on your horizontal axis (e.g., "January," "Q1," "Product A"). The Gap Width adjusts the empty space between these groups.

Here’s the step-by-step process:

1. Create Your Column Chart

First, make sure you have your data organized in Excel and a basic column chart created. Simply highlight your data, go to the Insert tab, and select a Column or Bar chart from the Charts group.

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

2. Select Your Data Series

Click on any one of the columns in your chart. When you do this, you’ll notice that all of the columns belonging to that same data series become selected at once. This is the correct selection - you don't need to select just a single column.

3. Open the "Format Data Series" Pane

With the data series selected, there are a couple of ways to open the formatting options:

• The Easy Way (Right-Click): Right-click on any of the selected columns and choose Format Data Series... from the dropdown menu.
• The Fast Way (Keyboard Shortcut): With the columns selected, press Ctrl + 1 (or Cmd + 1 on a Mac).

This will open a pane on the right side of your Excel window titled "Format Data Series."

4. Locate and Adjust the Gap Width

In the "Format Data Series" pane, make sure the icon for Series Options (it looks like three columns) is selected. Here you will find a slider and a percentage box labeled "Gap Width."

Here’s how to work with the Gap Width percentage:

• Decrease the percentage to reduce the space between column groups. A value of 0% means the columns for different categories will touch each other. This is rarely a good idea unless you're making a histogram.
• Increase the percentage to add more space between the columns, making them appear thinner.

Excel’s default is usually around 150% - 219%, depending on your version. Tweak this number until the chart feels balanced. You can either drag the slider or type a number directly into the box for more precise control. For most charts, a Gap Width between 50% and 150% looks clean and professional.

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

Understanding Another Key Setting: Series Overlap

Right next to the Gap Width option, you'll see another setting called Series Overlap. This does something different but is equally important, especially when you have multiple data series (like a clustered column chart).

• Gap Width controls the space between categories (e.g., the space between January's bars and February's bars).
• Series Overlap controls the space between series within the same category (e.g., in a chart comparing "Sales" vs. "Profit" for January, it controls how close the "Sales" bar and "Profit" bar are to each other).

How to Adjust Series Overlap:

The process is nearly identical to adjusting the Gap Width. You'll find the "Series Overlap" slider right above "Gap Width" in the Format Data Series pane.

• Positive Overlap (e.g., 50%): This makes the columns for different series move closer together and overlap. It can be useful for certain chart types but is often confusing in a standard column chart.
• No Overlap (0%): This makes the columns for different series touch each other within a category. This is the default setting.
• Negative Overlap (e.g., -50%): This adds a small gap between the columns for different series within the same category. Dialing this into the negative territory (like -20%) is a great way to add separation and clarity to your clustered column charts.

Example: Visualizing Campaign Performance

Imagine you have a clustered column chart showing "Ad Spend" and "Revenue" for three different campaigns. The categories are the campaign names.

• Adjusting the Gap Width changes the space between Campaign 1, Campaign 2, and Campaign 3.
• Adjusting the Series Overlap changes the space between the "Ad Spend" and "Revenue" bars within each campaign. Setting it to -25% would add a nice, clean separator between the two bars for each campaign.

Bonus Tips for Chart Aesthetics

Controlling column spacing is the first step. Here are a few more tips to make your charts look even better:

1. Use Lighter Outlines

Thick, dark outlines can make your columns look heavy. Select your data series, go to the Format tab, and under Shape Outline, choose a lighter gray or a slightly darker shade of the column's fill color. Or, create a modern look by getting rid of the outline entirely.

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

2. Create a Panel Chart Effect

For a unique, clean visual effect similar to what you see from dedicated data visualization tools, try this:

• Set the Gap Width to 0%. This will make all your column categories touch.
• With the series still selected, go to the Format pane.
• Select the Fill & Line icon (the paint bucket).
• Under Border, select "Solid Line" and choose "White" as the color.
• Increase the width of the line to 1.5 or 2 pt.

This creates an effect where the columns appear to have a consistent, clean white border separating them, which is a great look for dense data sets.

3. Don't Forget Data Labels

After spacing your columns perfectly, make sure the data is still easy to read. Add data labels so your audience doesn't have to guess the exact values. Right-click your data series and select Add Data Labels.

Final Thoughts

By mastering the Gap Width and Series Overlap settings, you can transform a busy, default Excel chart into a crisp, persuasive visual. This small detail goes a long way in making your data reports more digestible and professional, ensuring your key insights shine through.

While mastering formatting in Excel is a valuable skill, we know that spending time wrestling with sliders and formatting panes is often a frustrating part of the reporting process. That's why we built Graphed to automate the entire reporting cycle. You can connect your data sources directly and use simple conversational prompts to create beautiful, real-time dashboards in seconds, letting you focus on the insights instead of the manual setup.