Change The Width Of Bars In Excel Barcharts

The default settings for bar chart in Excel mean that they appear on your charts with a lot of space between them.  This default setting is sometimes not the look we want for our charts in particular if we want to compare the bars against each other.  To have them appear closer together or of a thicker width would be better.  It also will reduce wasted white space on the charts.   It’s easy to do this in Excel.

  1. Right Click on the bars
  2. Format data series
  3. Series Options
  4. Gap
  5. You will see a slider
  6. Slide left or right to change the % width between your bars

This will adjust the width of your bars making them closer together or further apart.

Other Excel Tips You Might Like

1. Create Combination Charts In Excel

2. Create A Self Expanding Chart In Excel

3. Create A Chart Super Quick With One Click


  1. Amy Toney says

    Hi Barb,
    Excel is automatically formatting the width of the bars in my chart. Is there a way to cutomize that? I tried to use your “Gap” tip, but that didn’t work. AMY

Leave a Reply

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