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.
 

Ask a Question

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.

Ask a Question

Similar Threads

How to create a bubble chart with more than 2 variables 0
How to chart months by financial year 0
Locking Chart Area 5
Excel 2003 Charts - color changing 2
How do I lock a chart so it will not update? 2
Linking Excel charts in Powerpoint 0
Chart not to pull Zero's 5
Copying embedded charts 1

Back
Top