Thread: Changing Bar Width

Hi everyone,

This seems like it should be a simple fix, but all the previous suggestions I found do no work.

I have a combined two axis bar/line graph, with four bars representing dollar amounts for a quarter of the year, and the line (against the other axis) represents number of accounts. The quarter is plotted on the X axis. The bars are only taking up 1/3 of the area, but I want them to fill nearly the entire area - I'd leave a small space to seperate. I cannot increase the width of the bar though. I have made both the major and minor units on the x axis 3 months and I have even tried reducing all the Gap settings down to zero with only a slight change. Can anyone offer any advice?

I have attached a copy of the chart.

Thanks,

Jeff

I figured it out. In the chart options, I changed the X axis to be "category" instead of automatic.

Thanks anyway.