How do I change the width of data columns in a column chart?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Diana - 05 Sep 2007 14:16 GMT

I created a column chart with 7 data series, and the data columns are very
thin, so you can't tell one series from another. I tried using overlap and
gap to increase the width of the columns, but that is not working. Any help
would be greatly appreciated.

Reply to this Message

Del Cotter - 05 Sep 2007 14:46 GMT

>I created a column chart with 7 data series, and the data columns are very
>thin, so you can't tell one series from another. I tried using overlap and
>gap to increase the width of the columns, but that is not working. Any help
>would be greatly appreciated.

It sounds as though you may have inadvertently triggered the
"Time-scale" behavior in the X axis. Go to Chart.. Chart Options.. Axes,
and select "Category" for the X axis instead of "Automatic", and see if
that helps.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
which goes to a spam folder-- please send your email to del3 instead.

Reply to this Message

Diana - 05 Sep 2007 17:26 GMT

Thanks for your help. Actually, since I had 7 series six months
apart,covering 67 months, the lines had to be skinny to fit in each month. I
changed my values from dates to odd numbers 1 through 23, made the axis
invisible and put in a text box with the dates.

> >I created a column chart with 7 data series, and the data columns are very
> >thin, so you can't tell one series from another. I tried using overlap and
[quoted text clipped - 5 lines]
> and select "Category" for the X axis instead of "Automatic", and see if
> that helps.

Reply to this Message

Andy Pope - 05 Sep 2007 14:50 GMT

Hi,

Sounds like your x axis is being treated as Dates rather than categories.
Right click chart and pick chart options. On the Axes tab check Xaxis
Category type.

Cheers
Andy

Signature

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

>I created a column chart with 7 data series, and the data columns are very
> thin, so you can't tell one series from another. I tried using overlap
> and
> gap to increase the width of the columns, but that is not working. Any
> help
> would be greatly appreciated.

Reply to this Message

Diana - 05 Sep 2007 16:40 GMT

Thanks for your help. Actually, since I had 7 series six months
apart,covering 67 months, the lines had to be skinny to fit in each month. I
changed my values from dates to odd numbers 1 through 23, mad the axis
invisible and put in a text box with the dates.

> Hi,
>
[quoted text clipped - 11 lines]
> > help
> > would be greatly appreciated.

Reply to this Message