Help,

have set up a named range using offset for the desired chart range,
this is a contiguous range with series in rows and the series names in
the first column (i can do without the xaxis labels for now)

the number of series is high, frm 20 - 150 ish (below the 256 max)

i create a stacked are using a nondynamic range that looks as i want

then right click on chart, source data, type in data range the sheet
name and name range.

Thant works, gives me the data i want

But when i go back to the chart to review the source datam it loses
the formula and just gives me the 'hard-coded' range.

Any ideas on how to give my dynamic chart some dynamism??