bar char - bar width

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jeff Reese - 13 Oct 2006 22:34 GMT

I've created a simple, standard bar chart in Excel. Oddly, Excel by default
has made the widths of the bars themselves extremely narrow. I have never
seen this behavior before. Any ideas what may be causing this and
suggestions on how I can fix it?

Thanks.

Signature

Jeff

Reply to this Message

Mike Middleton - 13 Oct 2006 22:52 GMT

Jeff -

To fix, in Excel 2003 and earlier versions: Format Data Series | Options |
Gap Width.

- Mike
http://www.mikemiddleton.com

> I've created a simple, standard bar chart in Excel. Oddly, Excel by
> default
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message

Jon Peltier - 14 Oct 2006 00:31 GMT

Is this weekly data, for instance? Excel might interpret dates and provide
seven slots for one weekly value, leaving you with six empty slots per
filled point. Change from a time scale axis to a regular category axis: go
to the Chart menu, Chart Options, Axes tab, and under Category (X) Axis,
change Automatic to Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______

> I've created a simple, standard bar chart in Excel. Oddly, Excel by
> default
[quoted text clipped - 3 lines]
>
> Thanks.

Reply to this Message