Column Chart Thickness of Bars

T

twinkle17

I need to graph the amount of concrete poured against the planned amount for
each week over about 60 weeks. When I create a Column Chart in Excel 2007
the bars in the chart are thin lines, I have tried to format the Data Series
and remove the gap width but this does not seem to have much effect.

I've also tried increasing the thickness of the border however this just
looks stupid and makes the data overlap.

Is there any way to fix this?

Cheers
 
J

Jon Peltier

The bars are narrow because you have one value and six blanks per week.
Right click the horizontal axis, choose Format Axis, and under Axis
Options - Axis Type - choose Text Axis. Excel recognized your X values as
dates and used the Date Axis option as the Automatic type.

- Jon
 
I

Ilkevz

Right click on chart and select chart options.
Then in the 'axes' tab select the "category" option beneath the "category X axis" option instead of "automatic".

Regards
 
J

Jos Argyle

Right click on chart and select chart options.
Then in the 'axes' tab select the "category" option beneath the "categoryX axis" option instead of "automatic".

Regards

Thanks a lot
 

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

Top