Try

Set rngYData = rngXData.Offset(0,1).Resize(,3)

HTH,
Bernie
MS Excel MVP


wrote in message ups.com...
Currently using the following code to grab an adjacent column:

Set rngYData = rngXData.Offset(0,1)

later on in the program:

.XValues=rngXdata
.Values=rngYdata

The above allows me to plot the following data:

County Year Estimate1
a 1981 500
a 1982 650

I would like to be able to add another series (or 2) and plot it.

County Year Estimate1 Estimate2 Estimate3
a 1981 500 590 600
a 1982 650 750 800

Can I adapt the above code to allow me to do this?

Mike