Highlight the data you want to present in the pie chart, including the labels, by dragging the mouse across the cells. Each chart can compare data only from the columns or the rows, but not from both.

Excel automatically inserts the graph, but it has no labels. Review the new green "Chart Tools" tab and ribbon at the top of the screen. If you don't see them, click the chart to enable them.