+ Reply to Thread
Results 1 to 6 of 6

Adding reference lines to a chart with primary and secondary axis

  1. #1
    Registered User
    Join Date
    01-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Angry Adding reference lines to a chart with primary and secondary axis

    Good day all! New to the forum! I have a chart with sales data on one axis and inventory on a secondary axis. I have the average of each columns of data and want to add a reference line to each axis with it's average. I have added the averages to my data set, but it only adds the reference line to my primary axis. I actually began by manually inserting two lines to the chart (which seems asinine). They actually didn't print because they weren't actually on the chart, but rather just on the spreadsheet behind. So neither solution is working for me right now. Please help, thanks!

    Ben

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Adding reference lines to a chart with primary and secondary axis

    can you post example file to illustrate your problem
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    01-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Adding reference lines to a chart with primary and secondary axis

    So.....how do I attach a file to a reply? I can't find anywhere to do that on here!

  4. #4
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Adding reference lines to a chart with primary and secondary axis


  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    19,831

    Re: Adding reference lines to a chart with primary and secondary axis

    Once you move a series to the secondary axis any new series added to the chart will also be on the secondary axis, which is the case for the "Avg Wrt Sls" series.
    If you select that series via the drop down box on Format ribbon you can change it to the Primary axis and it will appear.

  6. #6
    Registered User
    Join Date
    01-10-2014
    Location
    United States
    MS-Off Ver
    Excel 2010
    Posts
    4

    Re: Adding reference lines to a chart with primary and secondary axis

    Great! Thank you Andy!!

+ 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. Excel chart: Aligning secondary axis with primary
    By Harlort in forum Excel General
    Replies: 3
    Last Post: 04-04-2011, 10:26 AM
  2. Replies: 15
    Last Post: 07-26-2010, 04:35 AM
  3. Replies: 1
    Last Post: 05-03-2006, 09:20 PM
  4. Replies: 2
    Last Post: 05-03-2006, 09:20 PM
  5. Replies: 2
    Last Post: 05-03-2006, 09:20 PM

Tags for this Thread

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