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
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
agwalsh

8/22/2022 - Mon
Saqib Husain

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.

agwalsh

ASKER
Chart one or two?
Saqib Husain

Chart 2

All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck
ASKER CERTIFIED SOLUTION
byundt

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
agwalsh

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