+ Reply to Thread
Results 1 to 1 of 1

changing source data for "Lines on 2 Axes" graph

  1. #1
    Registered User
    Join Date
    09-07-2007
    Posts
    43

    changing source data for "Lines on 2 Axes" graph

    I can't seem to figure out how to modify the source data for a custom graph (specifically, the "Lines on 2 Axes" graph). I have named several ranges in the code up to this point, but I don't think I can use them because the source data is in the form of series collections (?), so I can't just use the SetSourceData command...right? Anyway, if someone could please explain this to me and propose a solution, I would be much appreciative. I recorded a macro to see if I could modify it accordingly, but I don't know enough about VB to do so.

    ActiveChart.SeriesCollection(1).XValues = "=Output!R17C3:R18C3"
    ActiveChart.SeriesCollection(1).Values = "=Output!R17C7:R18C7"
    ActiveChart.SeriesCollection(2).XValues = "=Output!R17C3:R18C3"
    ActiveChart.SeriesCollection(2).Values = "=Output!R17C6:R18C6"
    ActiveChart.SeriesCollection(3).Values = "=Blend!R3C15:R6C15"

    I can't figure out where the ranges are coming from here. They're obviously not cell references in the traditional sense, which is why I figure I can't use the ranges to which I've already assigned names. thanks in advance.
    Last edited by johndough185; 12-05-2007 at 09:33 PM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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