how to change gap width in excel quickly extendoffice normally the gap width is automatically calculated based on the date and chart area saying the chart area is fixed the space between two series points may be very narrow if there are many data serie how to make bars closer together in column graphs in the gap width option in excel for mac 2011 controls the spacing of bars in a column graph decreasing this percentage shrinks the empty space between columns by widening the columns themselves space between bars of excel chart excel help forum im not sure you can change the gap without changing the width of the bars but you can resize the chart to reduce the bar widths after did you try double clicking any of the bars in the chart an how do you change the width of charts columns microsoft the usual way to change the width of the vertical bars in a column chart type is to change the gap width in all versions of excel windows and mac select the data series by clicking on one of the b changing gap width between specific columns excelbanter excelbanter excel newsgroups charts and charting in excel changing gap width between specific columns reply linkback thread tools search this thread display modes 1 january 23rd 08 change the width of bars in excel barcharts how to excel 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 didnt work bar chart problem with size of bars and gap between them re bar chart problem with size of bars and gap between them a gap width of 100 seems to make the bars and the gap the same size then you can reduce the width of the chart or the plot area to get the how to reduce the width of a column chart in ms excel i want to reduce the width of the bar on value 1 9 in the attached column chart image i tried to change the gap width but it doesnt take values more than 500 how to reduced the width of bar on bar graph chart on excel i created a bar chart graph on excel now i want to reduce the width of bar i already set maximum gap width is there any way to reduce the bar as much i want to do removing gaps in an excel clustered column or bar chart part 2 youtube tv no long term contract loading unlimited dvr storage space live tv from 60 channels no cable box required cancel anytime working no thanks try it free find out why close