Delete the links from a chart to
the data range on a worksheet
|
You can convert the
formula so that it contains an array of values instead of pointing to the
data range on the worksheet. To do this, use the following steps:
- Click the chart to activate it.
- Select a series.
- Click the formula bar so that the insertion point is blinking in the
formula bar.
- Press Ctrl + =, or press F9 (They both provide the same
functionality).
- Press Enter.
|
|