Column and Bar Charts

  • Thread starter Thread starter PA
  • Start date Start date
P

PA

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

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

- Jon
 
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.
 
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.
Click to expand...

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.
 
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
 
Back
Top