Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
charting series
Hi,
I am trying to code a chart series using a program variable. Selecting the range by hand works ok but that's a hard-select range. Ie, this works: Sheets("Chart1").Select ActiveChart.SeriesCollection.NewSeries ActiveChart.SeriesCollection(3).Values = "=Query1! R2C7:R19C7" ActiveChart.SeriesCollection(3).Name = "=""25% Value""" ActiveChart.SeriesCollection(3).Select ... As you can see the .Values are hardcoded to R2C7 to R19C7. I would like to use a variable range that is determined by the program. I have tried this: ....Values = .Range(.Cells(2, 7), .Cells(c, 7)) where c is computed, but I get a compile error: Invalid or unqualified reference with the .Cells being highlighted. I have already dimmed cell as range. What am I missing here? And is this idea even do-able? TIA pj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting the Sum of Two, or More, Series of Data | Charts and Charting in Excel | |||
Help with Charting Data Series | Charts and Charting in Excel | |||
Charting a discontinuous series | Charts and Charting in Excel | |||
Time-Series Charting | Charts and Charting in Excel | |||
CHARTING W/INDIRECT SERIES | Charts and Charting in Excel |