Column Chart on 2 Axes

[twoshotsonce]

I've created a column chart using 2 axes. The first Y axis has a scale of 0 - 10,000 for "Hours per Year", the second Y axis has a scale of 0-60 for "% of budget". The Categories are "Sheriff/Jail" and "County Departments". The problem is that the columns appear one in front of the other for both categories and I've tried adjusting the "Overlap" and "Gap Width" settings to no avail. What I'd like is for the "hours per year" and "% of budget" columns to appear right next to each other for both categories.

Any suggestions? I've read through many of the FAQ's and was successful in creating the graph to this point as a result.

Thanks.

 

[Robert Mika]

This should help

http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html