Adjust OFFSET range

**BRISBANEBOB** · 06-22-2009, 08:08 PM

I'm trying to set the OFFSET range ChtY (in attached spreadsheet) to include all four columns. I can set it to four and combine it with a =SUM formula and it seems to work but not for setting a chart range.

Where am I going wrong?

Also, is it possible to use a check box to extend the range to, say, eight columns?

**DonkeyOte** · 06-23-2009, 07:02 AM

A Series needs to be a Vector ie 1 row or 1 column (not a matrix)

You would therefore need 4 named ranges - adding a further three series' to your chart each referring to the appropriate named range.

I've moved this to the Charting Forum so the Chart experts see it ... they may have a better solution.

**broro183** · 06-23-2009, 07:09 AM

hi,

If you're interested in some learning by guided discovery read through Jon's "dynamic" charting links: http://peltiertech.com/Excel/Charts/ChartIndex.html#D

hth
Rob