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.


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

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.