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
