| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
How to size the bars in a bar chart??
On Saturday, March 7, 2009 6:57:43 AM UTC-6, 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. Try changing the scale units from days to months. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Re-size Bars in Bar Graph | Charts and Charting in Excel | |||
| how do I get more than 19 bars on a bar chart | Charts and Charting in Excel | |||
| Help with bars in bar chart | Charts and Charting in Excel | |||
| Bars in a chart??????? | Excel Worksheet Functions | |||
| Calculating negative time & creating scrol bars for fixed size txt box. | Excel Discussion (Misc queries) | |||
Linear Mode
