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

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_rang e,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?