Logo 
Search:

MS Office Forum

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds

expand range to multiple columns

  Asked By: Jenna    Date: Nov 08    Category: MS Office    Views: 846
  

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?

Share: 

 

No Answers Found. Be the First, To Post Answer.

 
Didn't find what you were looking for? Find more on expand range to multiple columns Or get search suggestion and latest updates.




Tagged: