How do I add a title to a secondary axis?

Question

Split from this thread.

I have managed to add a secondary axis, but I cannot add an axis title?

Answer 1

What type of chart do you have? Some chart types can not display axis titles. These include radar, pie and donut charts.

BTW I deleted Arshad's answer because you told us in your question that you already have a secondary axis. Arshad's answer explained how to do what you already told us you did.

Answer 2

I have the same problem with a clustered column and line chart.  Using Excel for Mac Ver 15.16.  Added primary axis title but can not add secondary axis title as there is no option for secondary axis listed under "Add Chart Element" -> "Axis Titles".  Any help would be appreciated.

Answer 3

Can you provide a link to an example that has a chart with a secondary axis title? I think I might have figured it out, but I'm not sure. An example would help clarify. Upload an example to DropBox or OneDrive (an example without confidential or personal information) and reply with the link.

Thanks.

Answer 4

Here is how I made it by browsing the Help function in Excel:

1. Click in the plot area

2: Click the green "plus" appearing to the right

3: Hover "Axis Titles" to get the black arrow point to the right and then select the option "Secondary Vertical" from the new pop-up menu.

You should now have an axis title to the right hand side secondary axis.