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.

Instead of manually entering data when compiling your new data set, use Excel's functions to add together figures from your old data sets. This saves time and prevents typos. For example, if you ...