| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
adding data to a chart
Sounds like k = 0
HTH -- AP "inquirer" a écrit dans le message de u... 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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding data that is not graphed to chart | Charts and Charting in Excel | |||
| Adding extra data to a chart | Charts and Charting in Excel | |||
| adding data to chart | Charts and Charting in Excel | |||
| adding data to chart | Excel Discussion (Misc queries) | |||
| Adding Data Information to a Chart | Charts and Charting in Excel | |||
Threaded Mode
