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
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.
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.