Link to home
Start Free TrialLog in
Avatar of agwalsh
agwalsh

asked on

how to get two smaller data sets to use the secondary axis

I have a chart with 6 data sets - two of them (Oranges and TGs Oranges) of a smaller magnitude than then other 4 data sets. I can get Oranges on the secondary axis but how can I get TGS Oranges on the secondary axis as well. In the attached file I have two charts (the first one is what I want but it excludes TGS oranges). The second one includes all the data but it's not showing TGS as a secondary axis. What am I missing? Thanks you
Chartwith2secondaryaxis.xlsx
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Select the topmost line and send it to the primary axis. Another line will appear. Do the same to it. You will get your result.

Avatar of agwalsh
agwalsh

ASKER

Chart one or two?

Chart 2

ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

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 agwalsh

ASKER

Thank you both so much - it's the simple things sometimes!