The following procedure either excludes data from a chart without deleting the corresponding data from the datasheet or restores to the chart rows and columns that appear dimmed on the datasheet.
Switch to the datasheet.
Double-click the row heading or column heading of the row or column you want to remove from or add to the chart.
You can also exclude a data series from a chart by clicking the data series and then pressing DELETE.
In a bubble chart, Microsoft Graph excludes or includes two rows or columns for each data series.