Bar Chart Line Thickness

[shawn212]

For some reason, the bars in my stacked bar chart are very thin. I
there any way to make them wider? I already made the gap width 0...i
helped a little bit.

thanks
shaw

 

[Jon Peltier]

Shawn -

Is your X axis a time scale axis with dates? Even if you don't have data
for all the days, Excel reserves space for it. So if you plot weekly
data on an axis like this, you get six blank spaces and one data point.

Change the axis to a regular category axis by right clicking on the
chart, and choosing Chart Options. On the Axes tab, change the Category
(X) Axis to Category.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

 

[shawn212]

Thanks Jon...that was driving me crazy.

 

[Tom]

-----Original Message-----
For some reason, the bars in my stacked bar chart are very thin. Is
there any way to make them wider? I already made the gap width 0...it
helped a little bit.

thanks
shawn


---


.
Right click on chart, choose chart options, choose Axis,

Choose Category. I had same problem. This will fix it.