Share via

Center Alignment on Excel Bar Charts

Anonymous
2014-08-10T15:10:19+00:00

I use Excel 2010 and can not figure our how to activate the "Align Center" tab. I create a Bar Chart then click on Chart Tools, Format, Align and then most of the options, including "Align Center" will not activate.

Any clues on how to do this?

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments
Answer accepted by question author
  1. Vijay A. Verma 104.8K Reputation points Volunteer Moderator
    2014-08-10T16:03:33+00:00

    Align works on groups of objects, you need more than one object for this. Since, you are having a single chart, hence this option will not get activated.

    To experiment. copy and paste the same chart (or create a new chart or create another object like box or picture). Now select both (or more) the charts / objects by holding CTRL and now Align and Group will be activated. The purpose of align is align the selected objects (in your case, it is chart) with respect to each other.

    1 person found this answer helpful.
    0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2014-08-10T16:54:59+00:00

    Perhaps it would help if you told us what you want to do. Are you tryign to align the x-category lables with the bars in the column chart? best wishes

    0 comments