If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
How to size the bars in a bar chart??
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. |
#2
|
|||
|
|||
How to size the bars in a bar chart??
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 Bill wrote: 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. -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
Thread Tools | |
Display Modes | |
|
|