Forum Discussion
Having problem adding secondary axis to excel chart
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
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.
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.
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.
