Hi,
Simply selecting the series will not change sheet to show you data as
you have discovered. Try using the Source Data dialog, this will allow
you to swap sheets and see and adjust the data used.
Cheers
Andy
Boswell wrote:
I have a chart, on separate pg...same Wrkbk. Selcting a Series - does not
'outline' it's data returning to the Wrksht.
How do you EDIT?
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info