graphs

tinylawu · May 10th, 2002, 09:19 AM

I've recorded a marco doing some simple graph. So how that it works perfect but whenever I close the file and start again it just won't work. when I debug it the same line always wrong.
here is the macro.
ActiveChart.SeriesCollection(2).Values = "=MAIN!R25C16"
Thanks.

Corni · Jun 1st, 2002, 04:47 PM

According to your line of code, the SeriesCollection method returns only one value. Usually the series include more than one value, expressed as a range.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

May 10th, 2002, 09:19 AM	#1
tinylawu New Member Join Date: May 2002 Posts: 2	I've recorded a marco doing some simple graph. So how that it works perfect but whenever I close the file and start again it just won't work. when I debug it the same line always wrong. here is the macro. ActiveChart.SeriesCollection(2).Values = "=MAIN!R25C16" Thanks.

Jun 1st, 2002, 04:47 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	According to your line of code, the SeriesCollection method returns only one value. Usually the series include more than one value, expressed as a range.