Arrange or combine all of the data so that it creates a new data set. Since pie charts only use two categories, you should have no more than two columns of data. Add data together where necessary.

How to combine two or more columns in Excel 1. In Excel, click the "Insert" tab in the top menu bar. Then, click "Table." 2. In the "Create Table" dialog box that pops up, edit the formula so that ...

How to Put Two Sets of Data on One Graph in Excel. One of the advantages of using Excel as your spreadsheet application is that you can display a simple piece of information just as effectively as ...