multiple series on a graph
 

I have a worksheet with data on it such that I want to graph Column A vs
Column B, Column D vs Column E, Column G vs Column H, etc, etc,
scatterplot style. I've already written procedures that determine
exactly which cells are to be included.

I tried to create the graph manually while recording the code
generation in a macro and using that as a guide, but when adding new
series to the scatterplot,

'Dim aSeries As Series
'Set aSeries = ActiveChart.SeriesCollection.NewSeries

wouldn't allow me to modify the aSeries.Name, .XValues, or .Values
properties.

So instead of using SeriesCollection.NewSeries(), I'm trying
SeriesCollection.Add():

ActiveChart.SeriesCollection.Add
Source:=dataSheet.Range(determineDoubleRange(colum n))

My function, determineDoubleRange(column)), returns something like
"D15:E40"

But instead of Plotting Column D vs E like I want, it's creating two
series: D vs A, and E vs A.

Any guidance would be greatly appreciated. Thanks in advance.

--
ThatFella

multiple series on a graph
 

What line gave the error, and what was the error? Did you have the
apostrophes in front of the Dim and Set lines in the code, or only in
the message you posted?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

ThatFella wrote:
I have a worksheet with data on it such that I want to graph Column A vs
Column B, Column D vs Column E, Column G vs Column H, etc, etc,
scatterplot style. I've already written procedures that determine
exactly which cells are to be included.

I tried to create the graph manually while recording the code
generation in a macro and using that as a guide, but when adding new
series to the scatterplot,

'Dim aSeries As Series
'Set aSeries = ActiveChart.SeriesCollection.NewSeries

wouldn't allow me to modify the aSeries.Name, .XValues, or .Values
properties.

So instead of using SeriesCollection.NewSeries(), I'm trying
SeriesCollection.Add():

ActiveChart.SeriesCollection.Add
Source:=dataSheet.Range(determineDoubleRange(colum n))

My function, determineDoubleRange(column)), returns something like
"D15:E40"

But instead of Plotting Column D vs E like I want, it's creating two
series: D vs A, and E vs A.

Any guidance would be greatly appreciated. Thanks in advance.

multiple series on a graph
 

Jon Peltier wrote:
*What line gave the error, and what was the error? Did you have the
apostrophes in front of the Dim and Set lines in the code, or only
in
the message you posted?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

*

Thank you guys for the responses. Very shortly after posting this, my
code began to work. (I don't recall what I changed or even if I
actually knew what I changed). Having fixed the problem so soon after
posting and seeing that I had not yet received a response, I used the
"delete post" button offered by this web-based ng reader that I use.
The thread was deleted off of this web-based reader, but I guess the
feature doesn't work as well as it led me to believe. I only now found
your responses because I did a search for "ThatFella" to find another
post of mine.

I apologize. Next time I shall just reply to the message explaining
that I've resolved the issue and how I did it.

Thanks again for the responses.

BTW, the apostrophe's were definately NOT in my code. ;)

--
ThatFella

multiple series on a graph
 

Very shortly after posting this, my code began to work.

Happens all the time! The send button works wonders.

Next time I shall just reply to the message explaining that I've
resolved the issue and how I did it.

That might be handy, especially if someone else is having the same issue.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

ThatFella wrote:
Jon Peltier wrote:

*What line gave the error, and what was the error? Did you have the
apostrophes in front of the Dim and Set lines in the code, or only
in
the message you posted?

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

*


Thank you guys for the responses. Very shortly after posting this, my
code began to work. (I don't recall what I changed or even if I
actually knew what I changed). Having fixed the problem so soon after
posting and seeing that I had not yet received a response, I used the
"delete post" button offered by this web-based ng reader that I use.
The thread was deleted off of this web-based reader, but I guess the
feature doesn't work as well as it led me to believe. I only now found
your responses because I did a search for "ThatFella" to find another
post of mine.

I apologize. Next time I shall just reply to the message explaining
that I've resolved the issue and how I did it.

Thanks again for the responses.

BTW, the apostrophe's were definately NOT in my code. ;)