Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell references when creating charts
I want to refer to my cell range using
range(cells(row,column),cells(row,column)) as I am running this within a loop. However the only code I can get to work is the two forms below. Is there another way or can I use the above syntax a different way to get around this? Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SeriesCollection(1).Values = Sheets("EV3 flow").Range("B10:B446") ActiveChart.SeriesCollection(1).XValues ="='EV3 depth'!R10C2:R446C2" |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Cell references when creating charts
=range(cells(row,column),cells(row,column)).Addres s(1,1,xlA1,True)
or change xlA1 to xlR1C1 or just With Worksheets("Sheet1") set rng = .range(.cells(row,column),.cells(row,column)) End with ActiveChart.SeriesCollection(1).Values = rng -- Regards, Tom Ogilvy "Laura" wrote: I want to refer to my cell range using range(cells(row,column),cells(row,column)) as I am running this within a loop. However the only code I can get to work is the two forms below. Is there another way or can I use the above syntax a different way to get around this? Charts.Add ActiveChart.ChartType = xlXYScatter ActiveChart.SeriesCollection(1).Values = Sheets("EV3 flow").Range("B10:B446") ActiveChart.SeriesCollection(1).XValues ="='EV3 depth'!R10C2:R446C2" |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
convert relative cell references to absolute cell references via amacro? | Excel Discussion (Misc queries) | |||
Creating a chart that displays two cell references as one data po. | Charts and Charting in Excel | |||
creating cell references | Excel Discussion (Misc queries) | |||
Auto-increment data source cell references when copying charts | Excel Discussion (Misc queries) | |||
Creating cell references with variable values to use in Vlookup | Excel Discussion (Misc queries) |