Excel charts
- Open Excel and create a new blank workbook named Profit Analysis.
- Enter the worksheet title Don’s Donuts in cell A1.
- In cell A2 add a subtitle called “Profit Analysis”.
- 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 |
- Use the SUM function to create totals for territories, donut types, and grand total.
- Format the first row of numerical data and total row in Accounting Format.
- Format the rest of the numerical data in Comma Style.
- Center and bold the column labels.
- Bold the row labels.
- Apply the Heading 1 cell style to the title.
- Apply the Heading 4 cell style to the subtitle.
- Apply the Totals style to the total row.
- 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.
- Add a chart title called Profit Analysis and apply a chart style.
- Select the ranges A4:E9 and then insert a Clustered Column chart. Move the chart to a new worksheet named Profit Analysis Column Chart.
- Add a chart title called Profit Analysis and apply a chart style.
- Select the ranges A4:E5 and insert a Bar chart. Move the chart to a new worksheet named Profit Analysis Bar Chart.
- Add a chart title called Profit Analysis and apply a chart style.
- Name the Sheet Tab “Profit Analysis” and add a Tab Color.