From: <HIDDEN>
Newsgroups: comp.soft-sys.matlab
Subject: Re: create excel plot with MATLAB?
Date: Wed, 4 Jul 2012 22:37:18 +0000 (UTC)
Organization: The MathWorks, Inc.
Lines: 9
Message-ID: <jt2giu$dfg$>
References: <i1njgq$1og$> <i1nncr$dts$> <i1noc8$hsd$> <i1npis$6dt$>
Reply-To: <HIDDEN>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
X-Trace: 1341441438 13808 (4 Jul 2012 22:37:18 GMT)
NNTP-Posting-Date: Wed, 4 Jul 2012 22:37:18 +0000 (UTC)
X-Newsreader: MATLAB Central Newsreader 3536503
Xref: comp.soft-sys.matlab:772974

Hello, I have a question regarding this:

eC.SeriesCollection(1).Value = eS.Range('B1:B50');
eC.SeriesCollection(1).XValue = eS.Range('A1:A50');

The first line indicates the range for y-values and the second line for x-values.

My Question:
Is there a way, with ActiveX to select y-values over multuiple columns? For example: how can the y-range be set as B1:F50?