| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming
|
|||
|
|||
Variables and graphs
Try
ActiveChart.SeriesCollection(1).Values = "=three!R" & setin & "C11:" & Rsetout & "C11" -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "teepee" wrote in message ... Quick question.... If I have a VBA saying ActiveChart.SeriesCollection(1).Values = "=three!R3000C11:R4000tC11" can I replace it with ActiveChart.SeriesCollection(1).Values = "=three!RsetinC11:RsetoutC11" where setin and setout are declared variables? I'm a bit hazy on the syntax of this one. Cheers tp |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Summing graphs without differnt independent variables | Charts and Charting in Excel | |||
| 2-4 stacked bar graphs, two variables each, Y's vary same chart | Charts and Charting in Excel | |||
| automatically updating graphs based upon conditional variables | Charts and Charting in Excel | |||
| Automatic Graphs/ Dynamic Graphs | Charts and Charting in Excel | |||
| Variables and graphs | Excel Discussion (Misc queries) | |||
Threaded Mode
