Bar Chart Line Thickness

  • Thread starter Thread starter shawn212
  • Start date Start date
S

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
 
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/
_______
 
-----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


---
Message posted

.
Right click on chart, choose chart options, choose Axis,
Click to expand...
Choose Category. I had same problem. This will fix it.
 
Back
Top