Plotting more than 2 value in Y axis on a Pivot table

[sieger007]

I have a need to present 2 sets of values on the Y ( vertical ) axis but the Scales differ appreciably. I 'd like to know how can I present these so that I can appreciate the changes in both these values.
e.g. X fn of A B ( Y axis )
When I plot X against A & B because B has a HUGE range , variations in A appear minuscule.
How can I
<> address this scaling problem so that pictorially I can appreciate both changes in A and B against X
<> is there is Way to Plot A and B on different Y axis like one is on the LHS Y axis and other one on the RHS Y axis .
This is a PIVOT chart using data from another worksheet.
Thanks
Sam

 

[sieger007]

I figured this out
<> address this scaling problem so that pictorially I can appreciate both changes in A and B against X
Just need to know if this is poss.
<> is there is Way to Plot A and B on different Y axis like one is on the LHS Y axis and other one on the RHS Y axis .

I have a need to present 2 sets of values on the Y ( vertical ) axis but the Scales differ appreciably. I 'd like to know how can I present these so that I can appreciate the changes in both these values.
e.g. X fn of A B ( Y axis )
When I plot X against A & B because B has a HUGE range , variations in A appear minuscule.
How can I
<> address this scaling problem so that pictorially I can appreciate both changes in A and B against X
<> is there is Way to Plot A and B on different Y axis like one is on the LHS Y axis and other one on the RHS Y axis .
This is a PIVOT chart using data from another worksheet.
Thanks
Sam