# excel charts 2

1. Open Excel and create a new blank workbook named Profit Analysis.
2. Enter the worksheet title Donâ€™s Donuts in cell A1.
3. In cell A2 add a subtitle called â€œProfit Analysisâ€.
4. Starting in cell A4, enter the data below.
 Territory 1 Territory 2 Territory 3 Territory 4 Jelly 55894.34 45971.30 65762.50 48371.33 Glazed 34877.90 42877.21 48932.09 39872.10 Chocolate 52098.03 48342.10 48932.04 41834.23 Sprinkled 49335.28 46623.87 39865.30 40932.56 CrÃ¨me 42987.31 42875.15 43901.76 36089.21
1. Use the SUM function to create totals for territories, donut types, and grand total.
2. Format the first row of numerical data and total row in Accounting Format.
3. Format the rest of the numerical data in Comma Style.
4. Center and bold the column labels.
5. Bold the row labels.
6. Apply the Heading 1 cell style to the title.
7. Apply the Heading 4 cell style to the subtitle.
8. Apply the Totals style to the total row.
9. Select the ranges B4:E4 and B10:E10 and then insert a 3-D pie chart. Move the chart to a new worksheet named Profit Analysis Pie Chart.
10. Add a chart title called Profit Analysis and apply a chart style.
11. Select the ranges A4:E9 and then insert a Clustered Column chart. Move the chart to a new worksheet named Profit Analysis Column Chart.
12. Add a chart title called Profit Analysis and apply a chart style.
13. Select the ranges A4:E5 and insert a Bar chart. Move the chart to a new worksheet named Profit Analysis Bar Chart.
14. Add a chart title called Profit Analysis and apply a chart style.
15. Name the Sheet Tab â€œProfit Analysisâ€ and add a Tab Color.