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 After creating the filter view, within the chart setting you are given the choice to Include hidden/filtered data

Only top voted, non community-wiki answers of a minimum length are eligible