How to insert a tertiary vertical axis or add a Dual-Scale secondary vertical axis

%3CLINGO-SUB%20id%3D%22lingo-sub-1663025%22%20slang%3D%22en-US%22%3EHow%20to%20insert%20a%20tertiary%20vertical%20axis%20or%20add%20a%20Dual-Scale%20secondary%20vertical%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663025%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20community%2C%20I%20would%20like%20to%20insert%20a%20tertiary%20vertical%20axis%20in%20my%20graph%20or%20add%20a%20Dual-Scale%20secondary%20vertical%20axis.%20How%20could%20I%20do%20it%20in%20Excel%20(MS%20Excel%20for%20Office%20365)%3F%20It%20would%20be%20seen%2C%20something%20like%20the%20attached%20graph.%20Thank%20you%20very%20much%20for%20your%20support.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1663025%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1663165%22%20slang%3D%22en-US%22%3ERe%3A%20How%20to%20insert%20a%20tertiary%20vertical%20axis%20or%20add%20a%20Dual-Scale%20secondary%20vertical%20axis%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1663165%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F792406%22%20target%3D%22_blank%22%3E%40JavichoNodras%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EBroadly%20speaking%2C%20you%20prepare%20more%20than%20one%20scatter%20chart%20and%20then%20carefully%20overlay%20them%2C%20by%20aligning%20the%20plot%20areas%20to%20the%20underlying%20grid%2C%20using%20the%20alt%20key%20along%20with%20the%20mouse%20left%20button.%26nbsp%3B%20The%20overlaid%26nbsp%3B%20chart%20will%20need%20its%20area%20set%20to%20'no%20fill'.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor

Hi community, I would like to insert a tertiary vertical axis in my graph or add a Dual-Scale secondary vertical axis. How could I do it in Excel (MS Excel for Office 365)? It would be seen, something like the attached graph. Thank you very much for your support.

2 Replies
Highlighted

@JavichoNodras 

Broadly speaking, you prepare more than one scatter chart and then carefully overlay them, by aligning the plot areas to the underlying grid, using the alt key along with the mouse left button.  The overlaid  chart will need its area set to 'no fill'.

Highlighted