Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Specifiy Chart Data Range
I have a data source which varies in length, and I need to specify the data
range for the chart which displays this data. At present I have: ActiveChart.SetSourceData Source:=Sheets("Site Data").Range("C2:C500,G2:H500" _ ), PlotBy:=xlColumns Instead of going dwon to line 500 I want it to go down to a line number set by the variable "lastrow". Thanks, Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation to range names for Chart Source Data | Charts and Charting in Excel | |||
Chart empty with new data in the dynamic range chart. | Excel Discussion (Misc queries) | |||
Prob with ChartSource DataData Range | Charts and Charting in Excel | |||
Can I use named range in data range box when creating pie chart? | Charts and Charting in Excel | |||
Specifiy Printer (Location/name) | Excel Programming |