Exclude or include rows or columns of a datasheet from a chart

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.

1. Switch to the datasheet.

   How?

2. Double-click the row heading or column heading of the row or column you want to remove from or add to the chart.

Note: 

• 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.