Excel Intro:
Chart Wizard

Step-by-Step: Pie Chart with Wizard

---

What you will learn:

to use the Chart Wizard-      to select data and labels      to select chart type      to format chart title, legend, labels      to create a chart on separate sheet to print a chart

---

Start with: (Excel open to budget.xls from resource files)

To use the chart wizard you first select the data to be charted and also the cells that label this data.

1. Select the range A7:A13, the row labels in the Inflow section.
    
2. Hold CTRL down, scroll to the right, and select the range N7:N13, the totals for each row of the Inflow section.
   
3. Click on the Chart Wizard button. The Chart Wizard dialog opens at step 1 of 4.
    
4. Experiment:  Select each chart type and click on each of its subtypes. Press and hold down the bar below the subtypes. The pane will show how the data you just selected would look using that chart subtype. Which types look useful for this Budget data?
   
    
5. Select the Pie chart type and the first subtype on the top row.
   
   
6. Click on the button Press and hold to view sample and hold the mouse button down while you look at the preview pane in the dialog. It shows a rough estimate  of what your data will look like in this chart type.
   
    
7. Click on Next. Step 2 of the wizard opens, showing the ranges used for the chart.

The Data range uses absolute references. Those $ symbols scattered around do not mean money this time! If you move your data around on the sheet, the chart will change its references to match. Super helpful!


 Notice that the sheet name is included in the cell references, followed by an exclamation point. You can read the exclamation point ! as "bang" when saying the range aloud. Ranges are separated by a comma. So the correct format for the data range is NameOfSheet!$Column$Row:$Column$Row and put a comma between each range used for the chart. The Series tab is used when charting more than one data set at once.
 

8. Click on Next. Step 3 of the wizard opens to the Titles tab. The pie chart will change to show your changes.
     
9. For the Chart title type in  Budget 1998- Inflows 
   

10. Click on the Legend tab. A chart's legend tells what the chart colors represent. You can choose the location of the legend here.
      
11. Click on each choice to see what it does. Choose last to have the legend on the right.
    
    
12. Click on the Data Labels tab. You can choose what kind of labels to show on this tab.
      
13. Select Show percent or Percentage and check the box for Show leader lines.
    
     
14. Click on the Next button to continue. Step 4 opens.
     
15. Choose to create As new sheet and type in the  Inflows .
      
16. Click on the Finish button.

    Your finished chart appears on a new chart sheet named Inflows.

     

17. Click in the Formula bar and type your name, 2 spaces, the date, 6 spaces, Project 1: Excel Intro and press ENTER. A frame or text box containing your text appears in the center of the sheet.
    
     
18. Drag the frame/text box to the upper left of the chart's white background.

    

19. Click on Print Preview to see how this chart will print. Make corrections if necessary.
     
20. Click the Print button to print this sheet only. The default settings will print all pages of the active sheet(s). In this case there is only one page.

You do not need to save your changes.