How do I resize bars in chart

M

Mike Row Soft

I have a chart with column bars every six months. They are way too skinny.
How do I fatten them up? I set gap width to zero, but they are still too
skinny. I set scale major unit and minor unit to six months.
 
A

Andy Pope

Hi,

You need to change the axis from Time series to Category.
xl2003: Right click chart and pick Chart Options. On Axes tab set axis to
Category

xl2007: Right click axis and Axis Options page set the axis to 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

Wider bar charts 1
How to set scale of y axis for time 4
Chart formatting question 2
Creating Bar Chart 2
X-Axis Units Disappear in Stacked Area Chart (Excel 2007) 0
Chart shows all month-ends as 30th 3
presenting quarterly time series data 2
Column Chart Thickness of Bars 3

Top