Automatic bar width in stacked column chart too thin
 

Hi - I tried to post this question on 10 Jan but can't seem to find it so
suspect my posting was unsuccessful - apologies if I've missed it.

I've created a stacked column chart, but the bars are automatically coming
out as 1pt wide so I can't even see the colours - previously column widths in
a standard bar chart have been fine. The best I can do is to alter the gap
width in 'format data series- options' but this only makes it marginally
wider.

I'm guessing it has something to do with the data - this is as follows:
Column A = weeks of the year (31/12/07, 7/1/08, etc to 29/12/08)
Columns B-D = input data in time format ie 29 mins 15 secs as 00:29:15. The
three columns each record data for the time spent on a particular activity in
the week, ie running, swimming, cycling.
Column E = numeric value vetween 120-200 (ie average heart rate)

I've created the chart as follows:
Column A = dates form x axis
Columns B-D = data charted in stacked columns on primary axis
Column E = charted on secondary axis

Any pointers as to what I'm doing wrong gratefully received!

Thanks

Automatic bar width in stacked column chart too thin
 

Hi,

x axis is being treated as true dates rather than categories.
Right click chart and choose Chart Options. On axes tab set X axis to
Category rather than Time series

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rafcoles" wrote in message
...
Hi - I tried to post this question on 10 Jan but can't seem to find it so
suspect my posting was unsuccessful - apologies if I've missed it.

I've created a stacked column chart, but the bars are automatically coming
out as 1pt wide so I can't even see the colours - previously column widths
in
a standard bar chart have been fine. The best I can do is to alter the
gap
width in 'format data series- options' but this only makes it marginally
wider.

I'm guessing it has something to do with the data - this is as follows:
Column A = weeks of the year (31/12/07, 7/1/08, etc to 29/12/08)
Columns B-D = input data in time format ie 29 mins 15 secs as 00:29:15.
The
three columns each record data for the time spent on a particular activity
in
the week, ie running, swimming, cycling.
Column E = numeric value vetween 120-200 (ie average heart rate)

I've created the chart as follows:
Column A = dates form x axis
Columns B-D = data charted in stacked columns on primary axis
Column E = charted on secondary axis

Any pointers as to what I'm doing wrong gratefully received!

Thanks

Automatic bar width in stacked column chart too thin
 

Bingo - simple solution, many thanks!

"Andy Pope" wrote:

Hi,

x axis is being treated as true dates rather than categories.
Right click chart and choose Chart Options. On axes tab set X axis to
Category rather than Time series

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"rafcoles" wrote in message
...
Hi - I tried to post this question on 10 Jan but can't seem to find it so
suspect my posting was unsuccessful - apologies if I've missed it.

I've created a stacked column chart, but the bars are automatically coming
out as 1pt wide so I can't even see the colours - previously column widths
in
a standard bar chart have been fine. The best I can do is to alter the
gap
width in 'format data series- options' but this only makes it marginally
wider.

I'm guessing it has something to do with the data - this is as follows:
Column A = weeks of the year (31/12/07, 7/1/08, etc to 29/12/08)
Columns B-D = input data in time format ie 29 mins 15 secs as 00:29:15.
The
three columns each record data for the time spent on a particular activity
in
the week, ie running, swimming, cycling.
Column E = numeric value vetween 120-200 (ie average heart rate)

I've created the chart as follows:
Column A = dates form x axis
Columns B-D = data charted in stacked columns on primary axis
Column E = charted on secondary axis

Any pointers as to what I'm doing wrong gratefully received!

Thanks

Automatic bar width in stacked column chart too thin
 

On Jan 14, 4:44*am, rafcoles
wrote:
Hi - I tried to post this question on 10 Jan but can't seem to find it so
suspect my posting was unsuccessful - apologies if I've missed it.

I've created a stacked column chart, but the bars are automatically coming
out as 1pt wide so I can't even see the colours - previously column widths in
a standard bar chart have been fine. *The best I can do is to alter the gap
width in 'format data series- options' but this only makes it marginally
wider.

I'm guessing it has something to do with the data - this is as follows:
Column A = weeks of the year (31/12/07, 7/1/08, etc to 29/12/08)
Columns B-D = input data in time format ie 29 mins 15 secs as 00:29:15. *The
three columns each record data for the time spent on a particular activity in
the week, ie running, swimming, cycling.
Column E = numeric value vetween 120-200 (ie average heart rate)

I've created the chart as follows:
Column A = dates form x axis
Columns B-D = data charted in stacked columns on primary axis
Column E = charted on secondary axis

Any pointers as to what I'm doing wrong gratefully received!

Thanks

In Windows Vista and Excel 2007 I had to take a different approach -
Layout, Axes, Primary X Axis, More Axis Options, Check "Text Axis"
under Axes type.