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?

Here's how you can lock a chart in Excel so that it won't update:

1. First, select the chart that you want to lock.
2. Next, right-click on the chart and select "Format Chart Area" from the drop-down menu.
3. In the Format Chart Area pane that appears on the right-hand side of the screen, click on the "Properties" tab.
4. Under the "Properties" tab, you should see an option called "Don't move or size with cells". Check the box next to this option.
5. Click on the "Close" button to close the Format Chart Area pane.
6. Finally, save your Excel file. Your chart should now be locked and will not update when you open the file.

By checking the "Don't move or size with cells" option, you are telling Excel to treat the chart as a separate object that is not linked to the data in your worksheet. This means that the chart will not update when you make changes to the data in your worksheet.

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).


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Locking a Chart" wrote:

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?

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
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"Locking a Chart" <Locking a wrote in
message ...
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?