Share via

Make bars same width on identical Excel charts on Mac

Anonymous
2023-09-24T19:06:27+00:00

Hello, I have a number of identically sized Excel charts to which I've applied the format of the first.

BUT:

  1. how do I adjust the bar width to get them the same in each chart? The gap width and other settings are identical but the bars are different widths
  2. the % dots overlaid as a secondary series lie over the bars in some charts, but not in others. This seems random.

What do I need to adjust so each graph is identically formatted please?

Thank you

Microsoft 365 and Office | Excel | For education | MacOS

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

6 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Jim G 134K Reputation points MVP Volunteer Moderator
    2023-09-26T15:50:34+00:00

    If the number of columns of data represented is not the same in both charts, the column widths will not be visually the same.

    Can you provide a sample data set?

    Why a sample file is important for troubleshooting - - - - - - - and how to do it.

    0 comments