A
Alex A.
Hello, I need to update the X axis labels and Y Values
dynamically. In other words as the spreadsheet changes
my graph will update the X axis and Y axis values. The
Columns don't change so I just use numbers but the Rows
do change so I am trying to use a variable. My two
variables are x1 and x1. I tried the code below but to
no avail. I tried with and without parenthesis. Help!
'Update Graph1
Sheets("Chart2").Select
ActiveChart.SeriesCollection(1).XValues = "=Query!
Rx1C1:Rx2C1"
ActiveChart.SeriesCollection(1).Values = "=Query!
Rx1C5:Rx2C5"
'Update Graph1
Sheets("Chart2").Select
ActiveChart.SeriesCollection(1).XValues = "=Query!R(x1)
C1:R(x2)C1"
ActiveChart.SeriesCollection(1).Values = "=Query!R(x1)C5:R
(x2)C5"
dynamically. In other words as the spreadsheet changes
my graph will update the X axis and Y axis values. The
Columns don't change so I just use numbers but the Rows
do change so I am trying to use a variable. My two
variables are x1 and x1. I tried the code below but to
no avail. I tried with and without parenthesis. Help!
'Update Graph1
Sheets("Chart2").Select
ActiveChart.SeriesCollection(1).XValues = "=Query!
Rx1C1:Rx2C1"
ActiveChart.SeriesCollection(1).Values = "=Query!
Rx1C5:Rx2C5"
'Update Graph1
Sheets("Chart2").Select
ActiveChart.SeriesCollection(1).XValues = "=Query!R(x1)
C1:R(x2)C1"
ActiveChart.SeriesCollection(1).Values = "=Query!R(x1)C5:R
(x2)C5"