Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.programming

teepee[_4_] teepee[_4_] is offline

external usenet poster

Posts: 27

Variables and graphs

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

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Summing graphs without differnt independent variables	Sebastian Stormbo	Charts and Charting in Excel	5	July 18th 08 05:12 PM
2-4 stacked bar graphs, two variables each, Y's vary same chart	Writer on Path	Charts and Charting in Excel	1	October 22nd 07 08:11 PM
automatically updating graphs based upon conditional variables	GGC	Charts and Charting in Excel	2	June 22nd 06 01:31 PM
Automatic Graphs/ Dynamic Graphs	DanielWalters6	Charts and Charting in Excel	1	January 24th 06 09:29 PM
Variables and graphs	teepee	Excel Discussion (Misc queries)	7	January 2nd 06 11:47 PM

All times are GMT +1. The time now is 11:41 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us