Microsoft Office Tutorials and References
In Depth Information
Freezing a Chart
Freezing a Chart
Normally, an Excel chart uses data stored in a range. Change the data, and the chart is updated
automatically. Usually, that’s a good thing. But sometimes you want to “unlink” the chart from
its data range to produce a static chart — a snapshot of a chart that never changes. For example,
if you plot data generated by various what-if scenarios, you might want to save a chart that
represents a baseline so that you can compare it with other scenarios. You can freeze a chart in
h Convert the chart to a picture.
h Convert the range references to arrays.
Converting a chart into a picture
To convert a chart to a static picture, follow these steps:
1. Create the chart as usual and format it the way you want.
2. Click the chart to activate it.
3. Choose Home
Copy As Picture.
4. In the Copy Picture dialog box, accept the default settings and click OK.
5. Click any cell to deselect the chart.
6. Press Ctrl+V to paste the picture at the cell you selected in Step 5.
The result is a picture of the original chart. This chart can be edited as a picture, but not as a
chart. In other words, you can no longer modify properties such as chart type and data labels.
It’s a dead chart — just what you wanted.
Converting range references into arrays
The other way to unlink a chart from its data is to convert the SERIES formula range references
to arrays. Follow these steps:
1. Activate your chart.
2. Click the chart series.
The Formula bar displays the SERIES formula for the selected data series.
3. Click the Formula bar.
4. Press F9 and then press Enter.