bars overlap, how do I stop this?

I have data that uses different axis'. I want to show the data in bar
format, but the bars overlap. How can I show both bars without the overlap.

On your chart, rightmouse and select Chart Type, then select a chart style that does not overlap like the first standard Column or the first standard Bar chart

Originally Posted by stuckersubs

I have data that uses different axis'. I want to show the data in bar
format, but the bars overlap. How can I show both bars without the overlap.

Jon Peltier has instructions for a Column chart on Two Axes:

http://www.peltiertech.com/Excel/Cha...OnTwoAxes.html

stuckersubs wrote:
> I have data that uses different axis'. I want to show the data in bar
> format, but the bars overlap. How can I show both bars without the overlap.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html