capture/maintain information in summary/charts

[AEFelton]

My workbook has 10 Information-03 worksheet, 1 Charts and
1 Summary worksheets. How do I delete the 10 Information-
03 sheets but capture and maintain the information in the
Charts and Summarys sheets so I can continue the Charts
and Summary with Information-04 worksheets. I hope that
made sense.

AEFelton

 

[Debra Dalgleish]

Jon Peltier has instructions for changing a chart's series formulas. You
should be able to change the sheet names in your charts and summaries,
to switch from 03 to 04 information.

http://www.peltiertech.com/Excel/Charts/ChgSrsFmla.html