Click the Insert tab on the standard toolbar and click the Pie button. A blank chart will appear in the application window. Click and drag the blank chart to the right so that the entire table is viewable. Click the Select Data button in the Design menu on the Chart Tools toolbar. The Select Data dialogue box will appear. Click the Edit button in the Horizontal Axis Labels column on the right of the dialogue box.


Select cells B3 through D13 and press OK. Click the second to last option in the Charts Layout menu, which is "Layout 6." Click in the chart title field at the top of the pie chart and type "Monthly Expenses." The chart has been formatted and will display the amount spent in each category as a percentage of the total.
Create a pie chart.
{"src": "wikihow-all_test", "title": "How to Format an Excel Spreadsheet3"}