View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default 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.