To create a pie chart of the 2017 data series, execute the following steps.
Select the range A1: D2.
On the Insert tab, in the Charts group, click the Pie symbol.
Click Pie.
The result after choose pie.
The result after.
Note: Only if you have numeric labels, empty cell A1 before you create the pie chart. By doing this, Excel does not recognize the numbers in column A as a data series and automatically creates the correct chart. After creating the chart, you can enter the text Year into cell A1 if you like.