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?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"JamesWebster78" wrote in message
...
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?