3 Comments

    Leave a Reply

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

    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!

    3 Comments

      Leave a 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. You’ll never look at reports the same way again.

      Learn More

      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