Data Range

[Patrik Karlstrom]

Hello,

(I'm reposting this question from 9/26 with some minor changes to clarify)

I'm sitting here with a large number of Excel Graphs. I am [VERY] slowly
getting into Dyn Named Ranges, but I'm not there yet. So please don't go
ahead and explain in extended details how I will go about solving my problem
with that. It is a very interesting subject, but I have no time for now to
get into this new field. I need to solve my problem of the ranges expanding
when I insert a new row for a new week. I need to keep the range to the
following 12 weeks below the first cell and don't expand the range when I
insert a new row.

For now the range could be: Source Data - Data Range: ='SHEET
NAME'!$T$5:$U$18.

Any suggestion to prevent that the range expands to $T$5:$U$19 when I insert
a new row is very welcome. The T column is the dates and the U column is
the sales amounts, and when I insert a new week I want the range to stay at
$T$5:$U$18. Something probably have to be done about the Absolute Cell
References,
but I don't know what.

This doesn't apply for all my graphs. Some of them I need the range to
expand to include the new week.

Anyone? Thanks in advance!!

Patrik

 

[hgrove]

Patrik Karlstrom wrote...
...

For now the range could be:
Source Data - Data Range: ='SHEET NAME'!$T$5:$U$18.

Any suggestion to prevent that the range expands to $T$5:$U$19 when insert
a new row is very welcome. The T column is the dates and the U colum is the
sales amounts, and when I insert a new week I want the range to sta at
$T$5:$U$18. Something probably have to be done about the Absolut Cell
References, but I don't know what.

...

If you won't use dynamic ranges, then your only alternative is to us
separate data and graphing ranges. In other words, given you rata i
the range specified above, bot use that range as the source for you
graph. Instead, use, say, BY1:BZ14 containing the array formula

=OFFSET('SHEET NAME'!$T$5,0,0,14,2)

This range won't resize then you resize your data (as long as they'r
on different worksheets)

 

[Patrik Karlstrom]

I lost this response and found it later. A late thank you. My
microsoft.public.excel.worksheet.function is a mess right now. I can find
anything.

Patrik