3 Comments

  1. Very nice. I like it.

  2. George Mount says:

    Beautiful! I love that you included a picture of the sketched prototype as a reminder to, ahem, sketch something before futzing around with Excel charts!

  3. baconxl says:

    A variation of this trick will allow you to make side-by-side stacked column charts, as well!

Leave a Reply to George Mount Cancel reply

Your email address will not be published. Required fields are marked *

How to Adjust Your Column Chart’s Spacing in Excel

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

Sketch of chart.

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.

Basic excel stacked bar chart.

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

Edited stacked bar chart in Excel.

The secret strategy for nudging one of the columns over to the right: Add an empty column to your data table. Edited stacked bar chart in Excel with an extra column added.

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!

More about Ann K. Emery
Ann K. Emery is a sought-after speaker who is determined to get your data out of spreadsheets and into stakeholders’ hands. Each year, she leads more than 50 workshops, webinars, and keynotes for thousands of people around the globe. Her design consultancy also overhauls graphs, publications, and slideshows with the goal of making technical information easier to understand for non-technical audiences.

3 Comments

  1. Very nice. I like it.

  2. George Mount says:

    Beautiful! I love that you included a picture of the sketched prototype as a reminder to, ahem, sketch something before futzing around with Excel charts!

  3. baconxl says:

    A variation of this trick will allow you to make side-by-side stacked column charts, as well!

Leave a Reply to George Mount Cancel reply

Your email address will not be published. Required fields are marked *

Related Courses

Most “professional” reports are too long, dense, and jargony. Transform your reports with these practical tips.

Enroll

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

Learn More

SPONSORED

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

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

Learn More