Column and Bar Charts
 

One simple question, How do I make the columns in a column chart wider that
they are created by Excel 2003?

Thanks for help.

Column and Bar Charts
 

Double click on a column, and on the Options tab of the Format Series
dialog, reduce the Gap Width.

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


"PA" wrote in message
...
One simple question, How do I make the columns in a column chart wider
that
they are created by Excel 2003?

Thanks for help.

Column and Bar Charts
 

Thanks, that works, on most of our files that I experimented with. However,
the file needing to have the columns widened because they are far to narrow,
has a gap width of 10, and I do not know why.

"Jon Peltier" wrote:

Double click on a column, and on the Options tab of the Format Series
dialog, reduce the Gap Width.

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


"PA" wrote in message
...
One simple question, How do I make the columns in a column chart wider
that
they are created by Excel 2003?

Thanks for help.

Column and Bar Charts
 

On Mon, 7 Jan 2008, in microsoft.public.excel.charting,
PA said:

Thanks, that works, on most of our files that I experimented with. However,
the file needing to have the columns widened because they are far to narrow,
has a gap width of 10, and I do not know why.

Is it possible you have a cluster column chart, but that most series in
the cluster lack data values at each point?

If *all* series in the cluster lack values except one, you can set the
bar overlap to be 100%, with no ill effects.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Column and Bar Charts
 

Is the X axis a date scale, but you only have one data point per week? Your
gap is comprised of six empty days' of data, plus seven times the nominal
gap. Change to a category axis type (Chart menu Chart Options Axes tab).

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


"PA" wrote in message
...
Thanks, that works, on most of our files that I experimented with.
However,
the file needing to have the columns widened because they are far to
narrow,
has a gap width of 10, and I do not know why.

"Jon Peltier" wrote:

Double click on a column, and on the Options tab of the Format Series
dialog, reduce the Gap Width.

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


"PA" wrote in message
...
One simple question, How do I make the columns in a column chart wider
that
they are created by Excel 2003?

Thanks for help.

Column and Bar Charts
 

Changing to a category axis did the trick, thanks for the tip.

"Jon Peltier" wrote:

Is the X axis a date scale, but you only have one data point per week? Your
gap is comprised of six empty days' of data, plus seven times the nominal
gap. Change to a category axis type (Chart menu Chart Options Axes tab).

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


"PA" wrote in message
...
Thanks, that works, on most of our files that I experimented with.
However,
the file needing to have the columns widened because they are far to
narrow,
has a gap width of 10, and I do not know why.

"Jon Peltier" wrote:

Double click on a column, and on the Options tab of the Format Series
dialog, reduce the Gap Width.

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


"PA" wrote in message
...
One simple question, How do I make the columns in a column chart wider
that
they are created by Excel 2003?

Thanks for help.