Locking Charts

  • Thread starter Thread starter Dana Burton
  • Start date Start date
D

Dana Burton

Is there a way to lock a chart (that has links to update
it monthly)in excel so that it will not move after it is
saved?
 
For example, do you want to save a July version of the workbook, that
will always contain the data and chart for that month? If so:

1. Choose File>Save As, and save the file with a new name,
e.g. 200307Chart.xls
2. Select all the data, and choose Edit>Copy
3. Choose Edit>Paste Special
4. Select Values, click OK.

This will disconnect the data from the source that is updated, and the
data and chart will remain as they were in July.
 
Back
Top