Hi folks



I am using ACCESS 2010 pivotchart to plot 5 fields

fields 1 through 4 need to be stacked bars type using the primay Y axis (scale 0 to 75)
field 5 needs to be a line type using the secondary Y axis (scale 0.0 to 1.0

I have looked at MS info sites and other sites to figure out how to add a secondary Y axis but it is very confusing. Every time I follow the steps, the seconday axis does show up on the right but with a scale of 0 to 50 (as if it replicating the primary axis on the left).

Does any one have good instructions on how to:
  • create group 1 consisting of fields 1 to 4
  • create group 2 consisting of field 5
  • and somehow convince the pivotchart logic to create to different Y axis, one on the left for fields 1 through 4 and one on the right for field 5

Thank You
Mike