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

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.