So let’s go over some ways to exclude this data.
First, it’s possible for you to always exclude data when the chart is created.
And, I can extend this approach to exclude the quarterly totals as well.
I just need to hold down the control key and make separate selections.
So, selecting specific data first is a handy way to plot just the data you want.
Let me undo these changes, and let’s look at another way to filter the data.
It works really well when all the data is together in adjacent cells.
However, it’s possible for you to’t exclude cells that aren’t contiguous.
For example, I can’t use this technique to remove the first quarterly total.
Let me undo those changes and hit it one more time.
Another way to filter out data in a chart is to hide rows and columns manually.
This works because, by default, Excel ignores data in hidden rows or columns.
It’s a little cumbersome, but it’s simple and effective.
With chart filters, you typically include all the data and then filter out what you don’t want.
Now I just pick the chart and nudge the filter icon.
Simply uncheck those items you want to remove and click apply.
Notice when you’ve used the chart filters menu, the worksheet will still highlight all of the data.
However, the Select Data dialog will show what data is included and excluded.
And if I check or uncheck a box here, the Chart Filters menu changes to stay in sync.
