Altering Range in Code

**Janc** · 10-30-2009, 09:12 AM

Hi guys, I'm after a little help please...

I have the following code to create some charts but I need to amend the data range. Series1 is correctly grabbing the data from R2C2:R2C9, but I'm not sure how to change the range for series2 to also look at the same columns (currently series2 is looking to only C8).

TIA

Jan

Please Login or Register  to view this content.

**Andy Pope** · 11-01-2009, 11:43 AM

Can you post example workbook as my test of your code produces a second series with the following series formula

=SERIES(Percentages!$A$5,,Percentages!$B$5:$H$5,2)

Not correct, as it should be I5 not H5, but still not the problem you described.

**Janc** · 11-01-2009, 12:33 PM

Hi Andy

Thanks for the reply and please see attached example, I hope this shows the problem I'm having.

There may well be a more efficient way of creating the charts I need, but my knowledge is very limited as yet

**Andy Pope** · 11-02-2009, 06:27 AM

Try this,

Please Login or Register  to view this content.

**Janc** · 11-02-2009, 07:27 AM

Brilliant, thank you very much indeed!

Altering Range in Code

LinkBack

Thread Tools

Rate This Thread

Display

Altering Range in Code

Re: Altering Range in Code

Re: Altering Range in Code

Re: Altering Range in Code

Re: Altering Range in Code

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions