How to size the bars in a bar chart??

**Bill** · March 7th 09, 12:57 PM posted to microsoft.public.excel.charting

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** · March 7th 09, 02:42 PM posted to microsoft.public.excel.charting

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

**[email protected]** · August 3rd 12, 03:17 PM posted to microsoft.public.excel.charting

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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Re-size Bars in Bar Graph	SLKoelker	Charts and Charting in Excel	2	October 3rd 07 04:22 PM
how do I get more than 19 bars on a bar chart	brian scotr	Charts and Charting in Excel	1	September 24th 07 04:03 PM
Help with bars in bar chart	Antney	Charts and Charting in Excel	1	May 4th 07 05:28 PM
Bars in a chart???????	Gee	Excel Worksheet Functions	0	July 15th 05 11:36 AM
Calculating negative time & creating scrol bars for fixed size txt box.	Jonathan hill via OfficeKB.com	Excel Discussion (Misc queries)	4	February 12th 05 02:08 AM