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.
Who is Participating?
cekendricksConnect With a Mentor Author Commented:
Hi,  I am sorry for the elapse in time, regarding my response...I actually found that I had just made a rather dumb mistake in my attempt to form a second group.  So actually I resolved my problem about 5 minutes after posting the problem...Work, work, work.
Jeffrey CoachmanMIS LiasonCommented:
You can do this with a "Secondary" Access with a standard Chart...

Would this be an acceptable alternative?

Jeffrey CoachmanMIS LiasonCommented:
sample file
Jeffrey CoachmanMIS LiasonCommented:
cekendricksAuthor Commented:
I found that the error was on my part
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.