Bar Graph with Secondary Axis

[LouisT]

Good morning Everyone,
I'm hoping someone might know the solution to fixing this problem. I've created a Chart with only 2 Series. When they're both on the same axis it looks fine as any graph does, however i want to move one Series to the secondary axis. When i do this, the Bars in the graph overlap each other and even when i change the "Series Overlap", it still won't completely separate. Has anyone else had this problem and know how to resolve it?

Thanks in advance
LouisT

 

[thisoldman]

We cannot see what you see in your spreadsheet.

Can you show us a sample of the data or similar data? Just copy the cells in the sheet and paste them directly into the Reply text box.

Can you give us a link to a chart that shows what you are trying to accomplish by moving a series to a second axis?