Creating a Pie Chart. Resources:ÿDatabase Template, and Spreadsheet Guide on Excel?Open the Database Template, and click on the “Encounters” tab.ÿCreate a pivot table and a pie chart reflecting the dollar amount due to each of the three care providers.ÿFollow the instructions in the Spreadsheet Guide on Excel? to create the pivot table and the pie chart, and change the tab label.