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?