How-to Center Excel Clustered Chart Columns Over Horizontal Category Labels

When you have several series

Learn Excel Dashboard Course

Centered Columns Data

in one chart and only one of those series appear per Horizontal Label Category, you probably want to center the labels as the default will appear in their own series range.

Uncentered Columns

Here are the 2 quick tips to make that happen:





1) Double Click on any of the series and change the Series Overlap to 100%

Series Overlap to 100

2) Instead of a Clustered Column Chart, choose a Stacked Column Chart

Learn Excel Dashboard Course

Either one of these options will change the chart of data set you see above to a centered column chart over the horizontal axis categories.

Centered Columns



 

Alternately, if you have more than one column, but not one in are looking to remove columns to center the cluster of columns

Centered Columns Data with Many Gaps

Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

Check out this post: Removing-gaps-in-an-excel-clustered-column-or-bar-chart-part-2

Video Demonstration:





What other Quick Tips have you run across?

Steve=True





Want to Receive the Next Post?
Join My Newsletter
Subscribe
Give it a try, you can unsubscribe anytime.
Privacy Policy

4 COMMENTS

LEAVE A REPLY

Please enter your comment!
Please enter your name here