Project 3A Key Points

  1. A pie chart shows the relationship of each part to a whole. The size of each pie slice is equal to its value compared to the total value of all the slices. A pie chart displays data that is arranged in a single column or row, and shows the size of items in a single data series proportional to the sum of the items. A pie chart can have only one data series.
  2. Calculating values for a pie chart. Click the cell where you want to place the formula (D5) and type =. Enter the formula by typing the cell reference or by clicking the cell. In this case we are dividing the adjusted expenditures for a category (Airport) by the total adjusted expenditures. After you have finished entering the formula, press F4 to make the last cell you entered (total adjusted expenditures) an absolute reference -- a $ will appear before both the column letter and the row number. Copy the formula to the other rows and with the range still active, right click over the selection and then on the mini toolbar, select % and Center. You want the denominator to stay constant and you copy the formula, so it must be an absolute reference.
  3. Creating a Pie Chart and Moving a Chart to a Chart Sheet - To create a pie chart, you must select two ranges. One range contains the labels for each slice of the pie chart and the other range contains the values that add up to a total. The two ranges must have the same number of cells and the range with the values should not include the cell with the total.

    Withe the nonadjacent ranges selected (through holding down the control key), click the Insert tab, and then in the Charts group, click Insert Pie or Doughnut Chart. Under 3-D Pie, click the chart 3-D Pie to create the chart and to display the Chart Tools contextual tabs on the ribbon.

    On the Design tab, at the right end of the ribbon in the Location group, click Move Chart and then click the "New sheet" option button.. In the New sheet box, type Expenditures Chart and then click OK to display the chart on a separate worksheet in your workbook.
  4. Format a Chart Title by Applying a WordArt Style and Changing Font Size- To change the title of the chart, click the title and then type the new title in the formula bar and then hit Enter to place what you typed into the title. On the Format tab, in the Word Styles group, click to select a style. Drag through the text of the title, and then right click and change the font size.
  5. The text gives detailed instructions and diagrams showing the steps to perform the following:
    1. Formatting Chart Elements by Removing a Legend and Adding and Formatting Data Labels
    2. Formatting a Data Series with 3-D Effects
    3. Formatting a Data Series with a Shadow Effect
    4. Rotating a Pie Chart by Changing the Angle of the First Slice
    5. Exploding and Coloring a Pie Slice
    6. Formatting the Chart Area
  6. Edit a Workbook and Update a Chart - If you change the data, the chart automatically changes
  7. Use Goal Seek to Perform What If Analysis - Click the cell that contains a formula. You want to change the value of this cell to a value you specify by changing the value of another cell you specify. On the Data tab, in the Forecast group, click What-If Analysis and then click Goal Seek which opens the Goal Seek dialog box where the set cell is already specified and you then enter the "To value" and the "By changing cell" entries. "With Goal Seek", you can work backward from a desired outcome to find the number necessary to achieve your goal" (more on this in Chapter 4)
  8. Preparing and Printing a Workbook with a Chart Sheet

revised: 9/22/2021. Comments to Bill Pegram, wpegram@nvcc.edu