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