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
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
