This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
Trying to add a secondary axis on a line chart with two data series. I've followed the instructions on the Microsoft Support web page here:
"In the chart, select the data series that you want to plot on a secondary axis, and then click Chart Design tab on the ribbon. For example, in a line chart, click one of the lines in the chart, and all the data marker of that data series become selected. Click Add Chart Element > Axes > and select between Secondary Horizontal or Second Vertical."
However, when I select Add Element - Axes, no option for a secondary axis appears, only 'primary horizontal and vertical'
What am I doing wrong? Thx
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Answer accepted by question author
Select one of the series.
On the Format tab of the ribbon (to the right of the Chart Design tab), in the Current Selection group, click Format Selection.
Under Series Options, select Secondary Axis.