To add any kind of chart to a worksheet, select the data you want to chart, click the Insert tab ... the fields by which to filter your data. If you chose a Recommended PivotTable, you can tweak ...

Many solutions require more than a simple function or filter. For instance ... we’ll combine a VLOOKUP() function, a data validation list, and a PivotTable to create a simple application ...

and then going to Insert > Table. Again, you don’t have to take this step but it’s recommended if you want to add more rows of data later and make it easier to update your pivot table.