Dynamic Charts

[dbaggett]

Does the charts have to be on the same worksheet as the data when creating
dynamic charts?

[Ed Ferrero]

Hi dbaggett,

No, all the techniques described here work with charts on different sheets.

If you are having trouble writing the series formula, try building a chart
on the same sheet as the data, then cut and paste the chart onto a different
sheet.

Generally, you need to enter the chart series as
=SERIES(Sheet1!ser_nm,Sheet1!x_range,Sheet1!y_range,1)

Where the named ranges are;
ser_nm - the series name
x_range - obvious
y_range

Ed Ferrero
http://www.edferrero.com

> Does the charts have to be on the same worksheet as the data when creating
> dynamic charts?