+ Reply to Thread
Results 1 to 2 of 2

adding data to a chart

  1. #1
    inquirer
    Guest

    adding data to a chart

    I am trying to add a data series to an existing chart.

    I have defined k in the program and want to select cols k+7 and k+2 as
    the data form the sheet "Data" to add to the chart.

    I have:

    ActiveChart.SeriesCollection(2).Values = "=Data!R2C" & k + 7 & ":R24C" &
    k + 7

    ActiveChart.SeriesCollection(2).XValues = "=Data!R2C" & k + 2 & ":R24C"
    & k + 2

    but this does not select the right data - it actually selects data
    G2:g24 and b2:b24.

    Could someone tell me the correct syntax please or the correct way to do it?

    Thanks

    Chris

    Chris

  2. #2
    Ardus Petus
    Guest

    Re: adding data to a chart

    Sounds like k = 0
    HTH
    --
    AP

    "inquirer" <noreply@noreply.com> a écrit dans le message de
    news:44471751$0$10678$afc38c87@news.optusnet.com.au...
    > I am trying to add a data series to an existing chart.
    >
    > I have defined k in the program and want to select cols k+7 and k+2 as
    > the data form the sheet "Data" to add to the chart.
    >
    > I have:
    >
    > ActiveChart.SeriesCollection(2).Values = "=Data!R2C" & k + 7 & ":R24C" &
    > k + 7
    >
    > ActiveChart.SeriesCollection(2).XValues = "=Data!R2C" & k + 2 & ":R24C"
    > & k + 2
    >
    > but this does not select the right data - it actually selects data
    > G2:g24 and b2:b24.
    >
    > Could someone tell me the correct syntax please or the correct way to do

    it?
    >
    > Thanks
    >
    > Chris
    >
    > Chris




+ 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