I am relatively new to using pivot charts. I am creating a company performance presentation and I have found a lot of uses for the pivot charts. One thing that I see as an option is to add a second vertical axis to the chart. When I do this though, it seems as though all of the options for one axis affect both of them. My initial assumption was that I would be able to show a secondary scale on the chart to have a sort of overlay chart mixed in.
My end goal is to have a chart using columns for each month that are stacked with on time shipments on bottom and late shipments on top of the column (Upper Right chart on the column charts dialog in access 2007 -- called 100% Stacked Column) . I have this chart already done and working. What I want to add is a second axis that would overlay a chart of total shipments on top of the percentage chart. the overlay would simply be a line chart, but it would add a lot of meaning to see how our on-time shipments were affected by the volume of shipments.
So the things I need to know are: How to use a second axis independently of the first axis, and how to bind data to that second axis/