excel charts 2 – writinghub.net

excel charts 2 – writinghub.net

  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.

Writing Hub