Click "Insert" in Excel's ribbon. Click "Pie" in the Charts group, and click one of the "2D Pie Chart" options to create a blank chart. Right-click the chart.

See the screenshot below of the Excel spreadsheet after using Data Table for this example. I do not like one thing about this display — the reference in B9. I feel like it is confusing to a user ...

SEE: How to Extract Delimited Data Using Excel Power Query. How to filter a table in Excel. Excel allows you to apply a summarizing filter by clicking Filter in the Sort & Filter group on the Data ...

Select Analyze Data at the top and Excel automatically selects the table on your sheet. You can check suggested pivot tables and charts from the side menu. Select the button below to insert them.