1.      Open Microsoft Excel.

    2.      Click cell B1.

  Type Total.

    3.      Click cell A2.

Type Atlanta, press Enter.

Type Chicago, press Enter.

Type Detroit, press Enter.

Type Los Angeles, press Enter.

Type Orlando, press Enter

    4.      Click cell B2.

   Type 5, press Enter.

   Type 3, press Enter

   Type 12, press Enter.

   Type 6, press Enter.

   Type 4, press Enter.

    5.      Click File.

   Click Save.

   Click My Documents.

   Click 3 ½ Floppy (A:)

   Highlight Book1.xls.

   Type Graph #1.

   Click Save.

    6.      Click cell A1.

       Highlight cells A1 through B6.

    7.      Click Insert.

   Click Chart.

   Click Next.

    8.      Click Next.

   Highlight Total under Chart title.

   Type Favorite Cities.

   Type Cities under Category (X) axis.

   Type Number of Students under

   Value (Y) axis.

    9.      Click Legend tab.

   Click Show Legend to remove

   check mark.

10.      Click Data Labels tab.

      Click Show value.

      Click Next.

11.      Click Finish.

   New chart is added to document.

   New chart is selected.

12.    Drag upper left corner to column A,  

       line 7 (right below Orlando).

       Drag upper right corner to column I.

       Drag lower left corner to line 28.

13.    Click Format Chart Area.

Click Font tab.

Choose a Font.

Click OK.

14.    Click Favorite Cities.

Click Format Chart Title.

Click Bold for Font style.

Click 16 for Size.

Click OK.

15.    Click Cities.

Click Format Axis Title.

        Click Bold for Font style.

        Click 16 for Size.

        Click OK.

16.    Click Number of Students.

Click Format Axis Title.

Click Bold for Font style.

Click 16 for Size.

Click OK.

17.    Click Atlanta.

Click Format Axis.

Click 12 for Size.

Click OK.

18.    Click first bar.

Click Format Data Series.

Choose a color.

Click OK.

19.    Click Plot Area (gray area).

Click Format Plot Area.

Click the white box (under Area).

Click OK.

20.    Click 5 (on first bar).

Click Format Data Labels.

Click Bold for Font Style.

Drag 5 onto bar.

Drag 3 onto bar.

Drag 12 onto bar.

Drag 6 onto bar.

Drag 4 onto bar.

21.    Click 0.

Click Format Axis.

Click Scale tab.

Highlight Maximum number.

Type 12.

Highlight Major unit number.

Type 1.

Click Font tab.

Click 12 for Size.

Click OK.

22.    Click File.

Click Save.

You have completed Graph #1.

Boys/Girls Graph

1.      Open Microsoft Excel.

  2.  Click cell B1.

        Type Boys, press Tab.

        Type Girls, press Tab.

3.      Click cell A2.

Type Atlanta, press Enter.

Type Chicago, press Enter.

Type Detroit, press Enter.

Type Los Angeles, press Enter.

Type Orlando, press Enter.

4.      Click cell B2.

Type 3, press Enter.

Type 2, press Enter.

Type 5, press Enter.

Type 4, press Enter.

Type 1, press Enter.

5.      Click cell C2.

Type 2, press Enter.

Type 1, press Enter.

Type 7, press Enter.

Type 2, press Enter.

Type 3, press Enter.

6.      Click File.

Click Save.

Click My Documents.

Click 3½ Floppy (A:)

Highlight Book1.xls.

Type Graph #2.

Click Save.

   7.  Click cell A1.

Highlight cells A1 through C6.

 8.   Click Insert.

Click Chart.

Click Next.

9.      Click Next

Type Favorite Cities under Chart title.

Type Cities under Category (X) axis.

Type Number of Students under

Value (Y) axis.

10.        Click Legend tab.

Click Top.

11.        Click Data Labels tab.

Click Show value.

Click Next.

12.        Click Finish.

13.     Drag upper left corner to column

          A, line 7 (right below Orlando).

          Drag upper right corner to column I.

          Drag lower left corner to line 28.

14.   Click Format Chart Area.

  Click Font tab.

  Choose the same font you chose for   

  Graph #1.

     Click OK.

15.   Click Favorite Cities.

  Click Format Chart Title.

  Click Bold for Font style.

  Click 16 for Size.

  Click OK.

16.   Click Cities.

  Click Format Axis Title.

  Click Bold for Font style

  Click 16 for Size.

  Click OK.

17.   Click Number of Students.

        Click Format Axis Title.

       Click Bold for Font style

        Click 16 for Size.

        Click OK.

18.    Click Atlanta.

  Click Format Axis.

  Click 12 for Size.

  Click OK.

19.   Click first bar.

 Click Format Data Series.

 Choose a color.

 Click OK. 

20.   Click second bar.

 Click Format Data Series.

 Choose a color.

 Click OK.

21.   Click Plot Area (gray area).

 Click Format Plot Area.

 Click the white box (under Area).

 Click OK.

22.   Click 0.

 Click Format Axis.

 Click Scale tab.

 Highlight Maximum Number.

 Type 12.

 Highlight Major unit Number.

 Type 1.

 Click Font tab.

 Click 12 for size.

 Click OK.

23.   Drag all the numbers onto the bars.

24.   Center the Legend box under

       Favorite Cities.

       Click Format Legend.

       Click 14 for Size.

25.   Click File.

 Click Save.

 You have completed Graph #2.