Link to home
Start Free TrialLog in
Avatar of cekendricks
cekendricks

asked on

Pivot chart with dual data set measued at different scales

I am using Access 2007 to create graphical representations of certain database data.  I have a Pivot chart that measures the cost and the quantity of a particular item on a month to month basis.  Both cost and quantity are measured as line graphs.  The problem is that the cost is always so high that the quantity get buried in the mud.  I have be able to create a new series for the quantity, with it's own seperate Y axis scale.  However the secont measuring axis is alway the same as the first.  How do I change the scale of the new group so that I can bring it's line up out of the mud.
Avatar of Jeffrey Coachman
Jeffrey Coachman
Flag of United States of America image

You can do this with a "Secondary" Access with a standard Chart...

Would this be an acceptable alternative?

JeffCoachman
untitled.JPG
ASKER CERTIFIED SOLUTION
Avatar of cekendricks
cekendricks

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of cekendricks
cekendricks

ASKER

I found that the error was on my part