A
Alex A
Why won't excel let me assign the X and Y values for my
graph dynamically???? It is this line that is erroring
out:
XValues = "=Query!R" & CStr(x1) & "C1:R" & CStr(x2) & "C1"
Related Code:
x1 = IVSLH2Range.Row + 1 'Dynamic Row Assignment -
Starting Row Number
x2 = IVSLH2Range.Row + intRowCountIVSLH2 - 1 'Dynamic
Row Assignment - Ending Row Number
XValues = "=Query!R" & CStr(x1) & "C1:R" & CStr(x2) & "C1"
YValues = "=Query!R" & CStr(x1) & "C5:R" & CStr(x2) & "C5"
'Update Graph
Sheets("Chart2").Select
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(1).XValues = XValues
ActiveChart.SeriesCollection(1).Values = YValues
graph dynamically???? It is this line that is erroring
out:
XValues = "=Query!R" & CStr(x1) & "C1:R" & CStr(x2) & "C1"
Related Code:
x1 = IVSLH2Range.Row + 1 'Dynamic Row Assignment -
Starting Row Number
x2 = IVSLH2Range.Row + intRowCountIVSLH2 - 1 'Dynamic
Row Assignment - Ending Row Number
XValues = "=Query!R" & CStr(x1) & "C1:R" & CStr(x2) & "C1"
YValues = "=Query!R" & CStr(x1) & "C5:R" & CStr(x2) & "C5"
'Update Graph
Sheets("Chart2").Select
ActiveChart.PlotArea.Select
ActiveChart.SeriesCollection(1).XValues = XValues
ActiveChart.SeriesCollection(1).Values = YValues