Bar on chart are too thin

**rmedina** · 09-18-2009, 06:25 PM

The bars on the bar chart are very thin even though I have ample space between the axis marks. How can I make the bars fill the space? It's hard to read.

**shg** · 09-18-2009, 06:36 PM

Select the series, Chart tools > Layout tab, Format Selection, Series Options, Gap Width

**Andy Pope** · 09-19-2009, 06:46 AM

Another reason for skinny columns is the category axis being dates.
e.g. You have weekly data so the columns are space 7 days apart.

xl2003
Right click chart and pick chart options. On the Axes tab set X axis to Category rather than Automatic or Time Series

xl2007
Right click axis and pick Format Axis. On the Options tab pick Axis Type: Text Axis

**rmedina** · 09-30-2009, 12:53 PM

Thanks for your replies. It looks great now.

**f1rebolt** · 02-12-2013, 09:48 AM

Originally Posted by Andy Pope

Another reason for skinny columns is the category axis being dates.
e.g. You have weekly data so the columns are space 7 days apart.

xl2003
Right click chart and pick chart options. On the Axes tab set X axis to Category rather than Automatic or Time Series

xl2007
Right click axis and pick Format Axis. On the Options tab pick Axis Type: Text Axis

Thanks andy! Was a great Help. Cheers!!