| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning a Range to
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Assigning a Number Based on a Range. | Excel Worksheet Functions | |||
| Assigning a Number Based on a Range. | Excel Worksheet Functions | |||
| Assigning Variable Range | Excel Discussion (Misc queries) | |||
| Assigning scores to a date range | Excel Worksheet Functions | |||
| Assigning ranges for values (e.g., $1,005 the range is ">$1K to 5K | Excel Worksheet Functions | |||
Threaded Mode
