The simplest way I know to create "dynamic" charts is to create the chart
with a macro. Then all you have to do is have the specfic data page showing
and run the macro, and waza, a chart is born (or perhaps click the top left
cell of the "table". You can record many features in the macro, like
discovering the number of rows, the number of columns (with end down and end
right macro instructions), and use a loop to explicitly define the series
properly. I have found that Microsoft's built in discovery isn't reliable
enough.

For existing charts, I have the chart showing/on top, and then run a macro
and the chart gets formatted or "updated" with its "new" data.

"philcud" wrote:

On 29 May, 17:32, philcud wrote:
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??

BTW Excel 2003