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
Chartwith2secondaryaxis.xlsx
Microsoft ExcelMicrosoft Office
Last Comment
agwalsh
ASKER
Chart one or two?
Chart 2
ASKER CERTIFIED SOLUTION
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.
ASKER
Thank you both so much - it's the simple things sometimes!
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.