How do I lock a chart so it will not update?

  • Thread starter Locking a Chart
  • Start date
L

Locking a Chart

That's the question. I have my data in Excel and the chart in Excel but not
all the data cells are used. Everytimg I open the chart it wants to update
and I want it to stay the same.

Any ideas on how to lock the chart?
 
W

Wigi

Hi

Just a few ideas:

You could lock the cells that are shown in the chart.

Or you could copy the cells and paste as values (assuming formulas were used
that update when other cells change).
 
J

Jon Peltier

Paste a picture of the chart into the worksheet. Select the chart. Hold
Shift while selecting the Edit menu, choose Copy Picture. Choose the On
Screen and As Picture options. Select another cell and paste normally.

- Jon
 
Top