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