How to Adjust Your Column Chart’s Spacing in Excel

Jul 5th, 2016 / Data Visualization / , , ,

In my prior post, I sketched a few options for a performing arts organization’s fictional ticket sales data:

IMG_8105

I intentionally separated the year-by-year columns from the total column with a little extra space. I don’t want all the columns mushed together.

Easy to sketch on paper.

But easy in Microsoft Excel?

Yes!

Here’s the default Excel graph.

Yuck.

Emery_Stacked-Bar-Chart_Default

Here’s the mostly edited version: reduced clutter; custom color; labels directly beside the data; reduced gap width.

Emery_Stacked-Bar-Chart_Nearly-Done

The secret strategy for nudging one of the columns over to the right: Add an empty column to your data table. Emery_Stacked-Bar-Chart_Final-Version

Bonus: Download the Materials

Download my spreadsheet. Apply my secret to your own projects. Post a comment and let me know how you’ve applied this technique!

Related Courses

Most “professional” reports are too long, dense, and jargony. Transform your reports with these practical tips. You’ll never look at reports the same way again.
FREE

Enroll Now

Data visualization best practices, practical how-tos, tutorials in multiple software platforms, and guest experts. Designed with busy number-crunchers in mind.
$599

Enroll Now

SPONSORED

#f-post-el-35{display:none !important}

#f-post-el-35{display:none !important}
#f-post-el-35{display:none !important}

Enroll Now