Hi,
I'm trying to create a Pivot Chart (bar chart) with a Secondary Axis, but I'm having a problem with the bars overlapping. I've seen workarounds for normal charts whereby one creates "dummy" series to create space, but I don't know how you achieve this in a Pivot Chart. I'd prefer to have the bars adjacent without needing to create any unnecessary series. Below is a screenshot of what I'm seeing:
Overlapping Bars.JPG
Bookmarks