Microsoft Office Tutorials and References
In Depth Information
Unlinking a Chart Series from Its Data Range
Figure 6-16: A line chart that uses data in a table.
Figure 6-17: After filtering the table, the chart shows only data for September.
Unlinking a Chart Series
from Its Data Range
Typically, 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