Microsoft Office Tutorials and References

In Depth Information

**Converting range references into arrays**

Figure 93-1:
Applying picture styles to a chart that was copied as a picture.

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

Repeat these steps for each series in the chart.

Figure 93-2 shows a pie chart that has been unlinked from its data range. Notice that the Formula bar

displays arrays, not range references. The original data SERIES formula was

=SERIES(,Sheet3!$A$1:$A$6,Sheet3!$B$1:$B$6,1)