Having problem adding secondary axis to excel chart

%3CLINGO-SUB%20id%3D%22lingo-sub-1468516%22%20slang%3D%22en-US%22%3EHaving%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1468516%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20created%20an%20Excel%20table%20and%20chart%20with%20trend%20line%2C%20but%20I%20cannot%20add%20element%20for%20secondary%20axis.%20%26nbsp%3BIt%20does%20not%20appear%20as%20an%20option.%20%26nbsp%3BI%20would%20like%20a%20secondary%20axis%20for%20column%20H%20in%20the%20%22Slave%20Percentage%22%20worksheet.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1468516%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20chart%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469376%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469376%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701139%22%20target%3D%22_blank%22%3E%40wyake0%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EHello!%20You've%20posted%20your%20question%20in%20the%20Microsoft%20Teams%20space%20and%20I%20don't%20believe%20your%20question%20has%20anything%20to%20do%20with%20Microsoft%20Teams.%20I'm%20moving%20your%20question%20to%20the%20%5B%23%24dp5%5D%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2FExcel%2Fbd-p%2FExcelGeneral%22%20target%3D%22_blank%22%3EExcel%20space%3C%2FA%3E%20-%20please%20post%20Excel%20questions%20here%20in%20the%20future.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469494%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469494%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701139%22%20target%3D%22_blank%22%3E%40wyake0%3C%2FA%3E%26nbsp%3BYour%20file%20contains%20only%20column%20A%20and%20B%20and%20no%20column%20H.%20If%20you%20can%20repost%20a%20full%20dataset%2C%20we%20could%20try%20to%20help.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469556%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675276%22%20target%3D%22_blank%22%3E%40hynguyen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESorry%20about%20that.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1469584%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1469584%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701139%22%20target%3D%22_blank%22%3E%40wyake0%3C%2FA%3E%26nbsp%3BHow%20about%20this%20chart%3F%20Basically%2C%20I%20copy%20column%20H3%3AH11%20and%20paste%20onto%20your%20current%20chart.%20Then%20go%20to%20Select%20Data%20and%20click%20on%20Series%204%20on%20left%20pane%2C%20Edit%2C%20choose%20Series%20Name%20%3D%20header%20of%20column%20H.%20Finally%2C%20just%20go%20to%20Change%20Chart%20Type%2FCombo%20chart%20and%20pick%20that%20new%20Series%20Slave%20as%20Percentage%20as%20Line%20on%20Secondary%20axis.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1470427%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1470427%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675276%22%20target%3D%22_blank%22%3E%40hynguyen%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20really%20like%20what%20you%20did.%26nbsp%3B%20I%20modified%20slightly.%26nbsp%3B%20Still%20have%20one%20issue%20that%20I%20cannot%20fix%3A%20I%20need%20column%20E%20to%20be%20the%20third%20part%20of%20a%20stacked%20column%20rather%20than%20a%20line.%26nbsp%3B%20Thanks!!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1472835%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1472835%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F701139%22%20target%3D%22_blank%22%3E%40wyake0%3C%2FA%3E%26nbsp%3BAs%20requested.%20You%20can%20easily%20change%20it%20by%20right-clicking%20the%20chart%2C%20choose%20Change%20Chart%20Type%2C%20select%20Combo%20chart%20(bottom%20one%20of%20the%20chart%20type%20pane)%2C%20find%20your%20series%20(Slave)%2C%20change%20from%20Line%20to%20Stacked%20column%20et%20voila.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1473910%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1473910%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F675276%22%20target%3D%22_blank%22%3E%40hynguyen%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20are%20awesome!!!%26nbsp%3B%20Thanks%20so%20much!!%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1486960%22%20slang%3D%22en-US%22%3ERe%3A%20Having%20problem%20adding%20secondary%20axis%20to%20excel%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1486960%22%20slang%3D%22en-US%22%3E%3CP%3EIf%20your%20chart%20has%20two%20or%20more%20data%20series%2C%20only%20then%20you%20will%20have%20the%20option%20to%20select%20one%20of%20the%20data%20series%20and%20use%20the%20Format%20Data%20Series%20to%20plot%20the%20selected%20data%20series%20on%20a%20secondary%20axis.%20If%20your%20chart%20has%20only%20one%20data%20series%2C%20the%20secondary%20axis%20option%20is%20disabled.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I have created an Excel table and chart with trend line, but I cannot add element for secondary axis.  It does not appear as an option.  I would like a secondary axis for column H in the "Slave Percentage" worksheet.

8 Replies

@wyake0 

Hello! You've posted your question in the Microsoft Teams space and I don't believe your question has anything to do with Microsoft Teams. I'm moving your question to the Excel space - please post Excel questions here in the future. 

@wyake0 Your file contains only column A and B and no column H. If you can repost a full dataset, we could try to help.

@hynguyen 

 

Sorry about that.

@wyake0 How about this chart? Basically, I copy column H3:H11 and paste onto your current chart. Then go to Select Data and click on Series 4 on left pane, Edit, choose Series Name = header of column H. Finally, just go to Change Chart Type/Combo chart and pick that new Series Slave as Percentage as Line on Secondary axis.

@hynguyen 

 

I really like what you did.  I modified slightly.  Still have one issue that I cannot fix: I need column E to be the third part of a stacked column rather than a line.  Thanks!!

@wyake0 As requested. You can easily change it by right-clicking the chart, choose Change Chart Type, select Combo chart (bottom one of the chart type pane), find your series (Slave), change from Line to Stacked column et voila.

@hynguyen

 

You are awesome!!!  Thanks so much!! 

If your chart has two or more data series, only then you will have the option to select one of the data series and use the Format Data Series to plot the selected data series on a secondary axis. If your chart has only one data series, the secondary axis option is disabled.