Jan's Illustrated Computer Literacy 101 Logo:Jegsworks Jan's Illustrated Computer Literacy 101
Home > Jan's CompLit 101 > Working with Numbers > Intro > Ex. Excel 1-3
Icon: Arrow - Previous pagePrevious    NextIcon: Arrow - Next page

Jan's Working with Numbers

    Intro: Exercise Excel 1-3

Finished DocumentYou will create and adjust a column chart to go with the sheet from the previous exercise.

 

 

 

 

These exercises use files from the numbers resource files. The default location for these files is c:\My Documents\complit101\numbers\ You cannot make changes to these files and save them in the same place. Save the changed documents to your Class disk. This keeps the original resource files intact in case you need to start over or another student will be using this same computer.

Exercise Excel 1-3: Column Chart

What you will do: Select data cells and label cells
Create a column chart
Choose a layout
Edit the title
Save and print

Start with:Icon: Class disk, ex1-2-Lastname-Firstname.xlsx from  previous lesson

Create a Column Chart

  1. Icon: Class disk Open ex1-2-Lastname-Firstname.xlsx, if necessary, from your Class disk in the excel project1 folder.
    (You created this file in the previous exercise.)
  2. Icon: Class disk Save As ex1-3-Lastname-Firstname.xlsx
  3. Select Data series: Select the column labels, B4:G4, and the column totals in B21:G21.
  4. Chart: Use the buttons on the Insert tab to create a column graph.
    Apply a Chart Layout that includes a text box for a title.
    Title = Key Categories
    Do not show the legend or data labels. Select and delete them if they came with the layout. (There is not a layout with a title and no legend and no data labels.)
    Move the chart to a new sheet and name the sheet Column Chart.
  5. Header: Insert a header that shows the file name.
  6. Prepare to Print: Look at Print Preview.
    Make corrections if necessary. Be sure the orientation is Landscape.
  7. Icon: Class disk Save.
    [ex1-3-Lastname-Firstname.xlsx]
  8. Printer Print or submit electronically, as your teacher directs.
    Your chart may look different from the illustration below, depending on which layout you chose.

    Ex. 3 results