How do I resize bars in chart

  • Thread starter Thread starter Mike Row Soft
  • Start date Start date
M

Mike Row Soft

I have a chart with column bars every six months. They are way too skinny.
How do I fatten them up? I set gap width to zero, but they are still too
skinny. I set scale major unit and minor unit to six months.
 
Hi,

You need to change the axis from Time series to Category.
xl2003: Right click chart and pick Chart Options. On Axes tab set axis to
Category

xl2007: Right click axis and Axis Options page set the axis to Text

Cheers
Andy
 
Back
Top