How to size the bars in a bar chart??

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

Hi All,

I've clicked everywhere and can't see how I can change the width of bars in
a bar chart.

Can anyone help please.

Ta.
Bill.
 
Hi,

In xl2003 double click the bar/column and on the Series Option of the
Format dialog set the Gap width to a smaller value than the default 150.

In xl2007 display the Format dialog for the series and adjust the Gap
Width percentage, which is in the Series Option section.

If you have skinny bars caused by using dates as category labels the you
need to change the Axis to category rather than Time series.

Cheers
Andy
 
Hi All,I've clicked everywhere and can't see how I can change the width of bars in a bar chart.Can anyone help please.Ta.Bill.
Click to expand...

Try changing the scale units from days to months.
 
Back
Top