when you’ve got a chart, you may want to add or remove data series.
However, if the data series are not in contiguous cells, you’ll need to use another approach.
But, if you have an existing chart you want to build on, you might do that too.
Right go for the chart and choose Select Data.
Data series are listed on the left.
poke the Add button, then make a selection for the series name, and the series values.
When you click OK, the new series will be added to the chart.
However, if I remove the second data series, the data range selector are again visible.
Just smack the filter icon, and uncheck quiz 1 and quiz 2.
Now when the chart is selected, the data range selector will still show that all data is included.
But if I check the source data, both quiz 1 and quiz 2 appear as disabled data series.
you could work with either to include or exclude data series in an Excel chart.
