+ Reply to Thread
Results 1 to 3 of 3

Can't add a secondary y-axis

  1. #1
    Registered User
    Join Date
    01-17-2018
    Location
    Arnold, MD
    MS-Off Ver
    Microsoft Excel for Mac version 15.41
    Posts
    8

    Can't add a secondary y-axis

    Hello,

    I would like to add a secondary y-axis to a chart. However, when I select a data plot and click Add Chart Element > Axes, I do not see a choice to add Secondary Horizontal or Second Vertical. As the screenshot file shows, my only choices are Primary Horizontal and Primary Vertical.

    Thanks in advance.
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,803

    Re: Can't add a secondary y-axis

    In order to get a secondary axis, you have to assign at least one of the data series to the secondary axis, which is done in the "format series" dialog.
    1) Select the data series that you want to move to the (not yet existent) secondary axis.
    2) Format series -> find the "plot on secondary axis" option and select it.
    3) Exit the dialog. the secondary y-axis should automatically appear.
    4) Select the axis and format the axis as desired.
    5) If you want to add the secondary horizontal axis, you can now add it through the chart elements.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    01-17-2018
    Location
    Arnold, MD
    MS-Off Ver
    Microsoft Excel for Mac version 15.41
    Posts
    8

    Re: Can't add a secondary y-axis

    Thank you very much for your quick response which solved my problem.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 4
    Last Post: 09-15-2019, 12:09 PM
  2. Replies: 1
    Last Post: 10-08-2014, 06:36 PM
  3. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  4. Replies: 6
    Last Post: 12-07-2010, 02:54 PM
  5. Replies: 0
    Last Post: 06-13-2007, 09:41 AM
  6. Replies: 2
    Last Post: 08-12-2005, 08:05 AM
  7. Replies: 0
    Last Post: 07-13-2005, 05:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1