double Y axis chart

[tom culjat]

In excel 2007, I'm trying to create a double Y axis bar graph. The problem I'm having is that the bars overlap. When I try to adjust the overlap with the series overlap function, there is no response. It seems this functionality can only be applied to a single Y axis graph.

This particular type of graph existed in older versions of excel under custom graphs, which no longer appear as an option in the 2007 version.

Has anyone found a solution for this??

 

[Steve=True]

You can do this by splitting your data like such:

a b c d
r1 10 20
r2 9 12
r3 15 20
r4 7 19

Columns C and D can be put on a separate y axis and they won't overlap a or b

 

[Steve=True]

oops, my post didnt' show right.

data in r3 and r 4 are in C and d respectively

There are no data points in r3c1 and r4c1 and r3c2 and r4