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 Save your time - order a paper!Get your paper written from scratch within the tight deadline. Our service is a reliable solution to all your troubles. Place an order on any task and we will take care of it. You won’t have to worry about the quality and deadlines Order Paper Now |
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.