Excel 2007 How to change width of stacked columns

B

bowfin

When I create a stacked column chart, the columns appear as thin coloured
lines. How do I make them into normal size coloured vertical bars, please
 
S

Shane Devenshire

Hi,

Try right-clicking any column and choose Format Data Series, and on the
first tab, Series Options, reduce the Gap Width
 
A

Andy Pope

Hi,

Unexpected skinny columns is normally a sign that the x axis is using dates
and that you only have values for sporadic dates.
If so you can change the axis to be category rather than time series.

xl2003: Right click > Chart Options > Axes > X axis > Category
xl2007: Select X axis > Right click > Format axis > Axis Options > Text

Cheers
Andy
 
B

bowfin

Many thanks. That took me to the right area. The eventual solution, under
Axis Optios seems to be to use "Automatically select based on data" and "Base
Unit-Fixed-months"
Thanks again
bowfin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 stacked column charts 1
sideways stacked bar charts with line series on the same axis 0
Stacked bar Chart in Excel 2007 1
Stacked Color Charts 1
Format column widths from one table to a separate table on same page 1
Stacked Column Chart with gaps! 1
Multiple stacked clustered bars 1
Convert Error Bars to Series and Colour 1

Top