Thank You!
This tip came in extremely handy, after trying to get a 2nd axis for another data series on a pivot chart in Access and giving up several months ago, I searched again and came across your post. It worked like a charm!
Thanks again for coming back to post this after you figured it out.