+ Reply to Thread
Results 1 to 3 of 3

adding a new series to secondary axis

  1. #1
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    adding a new series to secondary axis

    What is the proper syntax for adding a new series to the secondary axis using a predefined range where:

    Please Login or Register  to view this content.
    The chart is already generated and so I'm trying the code below, but it throws an error on .Values = rng:
    Please Login or Register  to view this content.

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

    Re: adding a new series to secondary axis

    That code works for me.

    You need to provide more detail, perhaps post example file.

    What chart type are you using?
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    02-25-2013
    Location
    Colorado, US
    MS-Off Ver
    Microsoft 365 Apps
    Posts
    518

    Re: adding a new series to secondary axis

    Scatterplot. Not sure why it wasn't working. Everything was declared when I debugged it, so I used an alternate way and seems to be work this way. Maybe the chart type?
    Please Login or Register  to view this content.

+ 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: 5
    Last Post: 05-03-2020, 06:01 AM
  2. Non-overlapping bars when using some series on secondary axis
    By vikas.trades25 in forum Excel General
    Replies: 1
    Last Post: 05-10-2019, 05:26 AM
  3. Replies: 2
    Last Post: 10-08-2014, 08:04 PM
  4. Replies: 1
    Last Post: 10-08-2014, 06:36 PM
  5. Replies: 0
    Last Post: 06-13-2011, 11:11 AM
  6. create bar graph with two series and secondary y axis
    By macmullet in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-04-2006, 10:10 PM
  7. Stacked bar for multiple series + secondary axis
    By gilbertcn in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 10-25-2005, 03:05 AM

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