Microsoft Office Tutorials and References
In Depth Information
Tip 93: 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 may want to save a chart that represents a baseline
so that you can compare it with other scenarios. You can freeze a chart in two ways:
➤ Convert the chart to a picture.
➤ 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➜Clipboard➜Copy➜Copy As Picture.
The Copy Picture dialog box appears.
4. 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.
When you select the picture, Excel displays its Picture Tools contextual menu. You can use all of the
tools in Picture Tools➜Format, plus those available in the Format Picture dialog box (displayed when
you press Ctrl+1). Figure 93-1 shows a few examples of picture styles applied to a chart that was
copied as a picture.