How do I resize bars in chart

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.
 
A

Andy Pope

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
 
Top