View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Increasing width of columns in column chart

Is the category axis showing dates? And is the data weekly, not daily? This
means you have six blanks dates for each date with a value, and therefore
the gaps are very wide. Change to a category scale axis. Excel 2003: Chart
menu Chart Options Axes tab, choose Category option for the Category
axis. Excel 2007: Format Axis, about midway down the first tab, choose Date
Axis.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Shelly" wrote in message
...
I have a column chart created and the columns are like pin stripes - I have
tried reducing the gap and so forth but can't find a way to make the
columns
wide enough to be useful.