How to Reduce Space Between Bars in Excel Chart
Nothing is more frustrating than creating an Excel chart and having the bars look thin and lost with giant spaces between them. This common formatting issue can make your data hard to read and visually unappealing. This tutorial will walk you through exactly how to reduce the space between bars in any Excel chart, giving you full control over your presentation.
Why Adjust the Space Between Bars?
Before jumping into the "how," it's helpful to understand the "why." The spacing in your bar or column chart directly impacts how your audience interprets the data. The default Excel settings often leave too much white space, which can make it difficult to compare values and spot trends.
By reducing the gaps, you can:
- Improve Readability: Thicker bars and smaller gaps make the chart easier to read at a glance, especially when presenting lots of categories.
- Enhance Comparisons: Placing bars closer together helps the eye compare adjacent values more effectively.
- Strengthen Visual Impact: A well-proportioned chart looks more professional and communicates your data with more authority.
The Key to Spacing: Understanding Gap Width and Series Overlap
Excel gives you two primary controls to manage spacing in bar and column charts: Gap Width and Series Overlap. You'll find both in the "Format Data Series" pane. Simply right-click on any of the bars in your chart and select "Format Data Series..." from the dropdown menu. A new pane will appear on the right side of your screen.
Let's break down what each of these settings does.
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.
Gap Width: The Space Between Categories
Gap Width controls the amount of empty space between each set of bars (or categories). Think of it as the main street that runs between a city block of buildings. A wider street pushes the blocks further apart, a narrower street brings them closer together.
- The setting is a percentage, where the value is relative to the width of a single bar.
- The default is often 150%, meaning the gap is 1.5 times the width of one of your bars.
- Reducing this percentage makes the bars thicker and decreases the space between them. A common setting is between 30% and 80%.
- Setting it to 0% will make the bars for each category touch each other completely.
Series Overlap: The Space Within Categories
Series Overlap is used only when you have multiple data series - for example, comparing monthly sales for "Product A" vs. "Product B." This setting controls how the bars within a single category interact with each other.
- A negative percentage (e.g., -25%) creates a small gap between the bars within the same category, keeping them distinct but still grouped.
- A setting of 0% makes the inner bars touch at their edges.
- A positive percentage (e.g., +25%) makes the bars overlap one another, which can be useful for certain types of comparisons.
For most standard charts, you will primarily be concerned with adjusting the Gap Width.
Step-by-Step Guide: How to Reduce Gaps Between Bars
Let's walk through the process with a simple example. Imagine we have a basic column chart showing monthly sales. The default spacing is too wide.
Step 1: Open the Format Data Series Pane
As mentioned, the first step is to access the formatting options.
- Click on your chart to select it.
- Right-click on any of the blue bars representing your data series.
- In the menu that appears, click on "Format Data Series...".
This will open the "Format Data Series" pane on the right-hand side of your Excel window. Make sure you are on the "Series Options" tab, which is represented by a small bar chart icon.
Step 2: Adjust the Gap Width
You'll see a slider and an input box for "Gap Width." The default value is likely 150%.
- To reduce the space between the bars, you have two options:
Immediately, you'll see that the bars are now much thicker, and the gaps between them are significantly smaller. This makes the data points look much more prominent and connected.
Step 3 (Optional): Adjust Series Overlap for Clustered Charts
What if you're comparing two data series on the same chart, like quarterly sales for 2022 vs. 2023?
In this scenario, after you adjust the main "Gap Width" to bring the clusters (the calendar quarters) closer together, you might also want to fine-tune the space between the 2022 bar and the 2023 bar within each quarter.
- Open the "Format Data Series" pane as before. You might need to do this for each series if you want them to behave differently, but a change to one often applies to both.
- Find the "Series Overlap" slider. The default might be a negative number, creating a small gap.
- To make them touch, set it to 0%. To make them overlap, use a positive number like 10%. To add more space, use a more negative number like -10%.
This gives you precise control over both the inner and outer spacing of your chart's bars.
Practical Tips for Better Chart Spacing
Adjusting the gap width is easy, but here are a few extra tips to ensure your chart sends the right message.
Don't Go to Extremes
While reducing the gap is good, setting it to 0% can sometimes be problematic. If your bars don't have a border, setting a 0% gap width will cause them to blend together into one solid block, which looks like a histogram but makes individual categories impossible to distinguish. If you do want your bars to touch, make sure to add a thin, solid border around them.
- To add a border, right-click the bars, select "Format Data Series...", go to the "Fill & Line" tab (the paint bucket icon), click on "Border," and choose "Solid line."
Maintain Consistency
If you're creating a dashboard or report with multiple bar charts, try to use a consistent Gap Width across all of them. This creates a more cohesive and professional look throughout your document. An audience shouldn't have to re-adjust their eyes for a different visual style on every chart.
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.
Consider Your Audience and Medium
How will this chart be viewed? If it's part of a live presentation projected on a large screen, slightly thicker bars with smaller gaps (e.g., 50-75% gap width) will be easier to see from a distance. If it's in a dense, printed financial report, you might need to find a balance that presents the data clearly without taking up too much page space.
Don't be afraid to experiment. Play with the Gap Width setting until you find the value that best tells your data's story.
Final Thoughts
Getting your charts to look just right in Excel often comes down to mastering small but powerful formatting tools like Gap Width and Series Overlap. By taking a few seconds to adjust the spacing between your bars, you can transform a sparse and hard-to-read chart into a clear, professional visual that effectively communicates your insights.
While fine-tuning charts is a necessary skill, it's often part of a manual reporting process that drains hours every week. Instead of exporting data and building visualizations from scratch, we built Graphed to do the heavy lifting for you. You can connect your data sources in seconds and create live, interactive dashboards just by describing what you need in plain English - no wrestling with formatting panes required. The reports are always up-to-date and formatted perfectly, saving you time to focus on strategy instead of report-building.
Related Articles
Facebook Ads For Personal Trainers: The Complete 2026 Strategy Guide
Learn how to effectively use Facebook ads for personal trainers in 2026. This comprehensive guide covers targeting strategies, ad creative, budgeting, and optimization techniques to help you grow your training business.
Facebook Ads for HVAC Companies: The Complete 2026 Strategy Guide
Learn how to run high-converting Facebook ads for HVAC companies in 2026. This guide covers targeting, creative strategies, and proven campaigns that drive real leads.
Facebook Ads for Florists: The Complete 2026 Strategy Guide
Learn proven Facebook advertising strategies for florists in 2026. Target the right audience, create compelling visuals, and optimize your ad budget for maximum ROI.