Google Sheets – How to Create a Pie Chart Without Certain Categories

google sheetsgoogle-sheets-charts

I have a list of data, showing 4 items. Cats, dogs, giraffes, eggplant.

I want to create a pie chart in google sheets that shows the pie with just cats, dogs, and giraffes. I don't want to show the chart with eggplant.

Is there a way to print out the chart without one or two categories from the list of data?

So instead of it showing this:
e

I would like it to show this chart, but without me needing to sort, deleted, manipulate the data.
enter image description here

Best Answer

You can do it by creating a new filter view and filtering out eggplant

  • Go to menu > Filter views
  • Create new filter view
  • Deselect eggplant
  • OK

enter image description here

After creating the filter view, within the chart setting you are given the choice to Include hidden/filtered data

Related Topic