How to make chart columns thicker

[Bobby]

Hi
I am using excel 2007. I am trying to create a chart with 20 weeks in
the x axis. The chart type is Column, clustered column. The chart
displays two lots of data.

The problem is, the columns are displayed as very thin, in fact
they're little more than lines, yet there is a lot of room on the
chart for them to be much thicker.

How do I make the columns thicker? The chart just looks daft at the
moment.

Thanks for any help

Colin

 

[Bobby]

Ok, brain in gear now, I've worked out what was wrong. The problem was
that the x-axes was recognising the data as a date. I told it that it
was text by going into Layout / axes / horizontal axes / more options,
and it works fine now.

Thanks

 

[Ed Ferrero]

Hi Colin,

Right-click the series, select Format Data Series...
Make the gap width smaller using the slider.

Ed Ferrero
www.edferrero.com