Widen Chart Columns

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm using a stacked column format. I want to show data for about 3 weeks (1
week in each column). Everything looks fine, except the column seems very
narrow. How do I change the width of the column on the chart? Thanks
 
Hi,

Double click column and adjust the GapWidth property on the series
option tab.

Also check the categroy axis is not being plotted as true dates as this
will leave big gaps between non consectutive dates.
Right click chart and choose Chart Options. On Axis tab set x axis to
Category.

Cheers
Andy
 
In Excel 2007, you need to change the information in the column to text
instead of a date. This will widen the bars on the graph. I could not find
a place to make it a "category" in 2007 (which is what I did with the
previous version).
 
In xl2007 you need to select the axis.
CTRL+1 to display the format dialog. Axis Options > Category as Text.

Cheers
Andy
 

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

Bar Widths 2
Charting Dated Data 1
Widening Cluster Chart Columns 2
Stacked Columns with different series in each column 0
Automatic bar width in stacked column chart too thin 3
How do widen columns in a column chart? 3
Problem with stacked column chart 5
Stacked Chart (per month per year) 1

Back
Top