Microsoft Office Tutorials and References
In Depth Information
Unlinking a Chart Series from Its Data Range
If you delete a name that is used in a chart SERIES formula, the chart will not
revert back to the range address. The (now) invalid names will remain in the
SERIES formula and the chart will not display properly. You’ll need to
reestablish the ranges used by the chart or recreate the chart.
As I noted previously, a SERIES formula cannot use worksheet functions. You can ,
however, create named formulas (which use functions) and use these named formulas
in your SERIES formula. As you see in Chapter 7, this technique enables you to
create “dynamic” chart series that update automatically when new data is entered.
Unlinking a Chart Series
from Its Data Range
Normally, an Excel chart uses data stored in a range. Change the data in the range,
and the chart updates automatically. In some cases, you may want to “unlink” the
chart from its data ranges and produce a static chart — 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 some baseline so that you can compare it with
other scenarios. There are two ways to create such a chart:
Convert the chart to a picture.
Convert the range references to arrays.
Converting a chart to a picture
To convert a chart to a static picture:
1. Create the chart as usual and make any necessary modifications.
2. Click the chart to activate it.
3. Press the Shift key and choose Edit
Copy Picture. The Copy Picture dialog
box offers several options. For best results, choose As Shown When Printed
for the Appearance option, and As Shown On Screen for the Size option.
4. Click any cell to unselect the chart.
5. Choose Edit
The result is a picture of the original chart. This picture can be edited as a
picture, but not as a chart. In other words, you cannot longer modify properties such
as chart type, data labels, and so on.