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

Connect with an expert
Contact us
Expand your skills
Explore training

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.

×