Wider bar charts

J

JamesWebster78

I made a combination line chart/stacked bar chart. The bars are really skinny
and sitting all the way to the left in their interval. The gap is zero and
the overlap is 100 but the bars are too skinny. It looks like excel thinks it
should leave room to plot side-by-side bars but there are none--only stacked
bars. Can you help me fatten these bars up?
 
J

Jon Peltier

This is a common problem if the data are weekly values and the X axis is a
date scale. The base unit of the axis is days, so your bars each take up to
1 day, but then there are six empty days in between, resulting in this wide
gap.

Go to Chart menu > Chart Options > Axes tab, and change the Category (X)
Axis selection to Category. This will treat each X value not as a date but
as a distinct label without skipping six days between weekly values.

- Jon
 
Top