Hi,
You would need to include the sheet or workbook
=Sheet1!Test
You will find plenty of information in these pages
http://peltiertech.com/Excel/Charts/Dynamics.html
Cheers
Andy
Tigerxxx wrote:
Hello,
How can I plot a chart where the data points to a "named range"?
If the name of my range is "test", what is the correct syntax to put in the
data tab...I tried:
=test
="test"
.....but none of them seemed to work.
Thank you
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info