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)
Search JabSto ::




Custom Search