Computer Training

Creating a Basic Spreadsheet

Creating a Chart

Use the example spreadsheet created in the brief exerciseon the web page Changing Column Widths. To generate a chart select the cells and categories that will be used in the chart.

1. Open the example spreadsheet.
2. Click and hold the mouse button down and drag the mouse over the cell range (C5:H6). Leave the cells selected.

3. Click on the Chart Wizard icon located on the Standard Toolbar. This will open the Chart Wizard dialog box, which contains several templates that you can view using the selected data. Pick a chart style from the template shown and then press the Press and Hold View button. A sample of your data is then display using the selected chart.
   
   
   In this example, choose Pie as the Chart type and the Chart sub-type Pie with a 3-D effect (1^st row, middle pie). As you proceed, the Chart Wizard will walk you through four steps.
4. Click on the Next button to proceed. In this step you must determine if you want the data range as columns or rows. Making this choice effects how the chart is interpreted. Make your choice and then preview it. You may use the Back button to change your choice.
5. Click on the Next button to proceed to Step (2). Although there are six Index tabs to help format a chart, this exercise only requires using two.
6. Click on the tab Title and then type Loose Change Cafe in the Chart Title Box. Click on the index tab Legend. For this exercise uncheck the box Show Legend.
7. Click on the index tab Data Labels and then place a checkmark in the boxes listed for Series Name, Percentage, and Show Leader Lines. Click on the button Next .
8. In this last step, the wizard asks how the chart is to be placed, as a new worksheet or as a new object embedded inside the current or inside another worksheet in this workbook. For this example, check the box as an object. Click on the button Finish to insert the chart inside the current worksheet.
   

As an object

1. Place the mouse cursor on the chart, hold down the mouse button and drag the chart's right corner diagonally to cell (H14). Release the mouse button. This is just an example reference point.
   Notice that the cursor changed to a 4-headed arrow as the chart was moved.
2. Next, hold down the Ctrl key and drag the chart's bottom left hand corner diagonally to cell (C28).
   

Formatting a Chart

1. Place the mouse pointer inside the chart area and double-click the mouse to open the Format Chart Area dialog box.
2. Click on the button Fill Effects to access one of the four index tabs. Each tab, Gradient, Texture, Pattern, and Picture provide various background options in colors, textures, patterns, and the ability to use a picture.
3. Click on the tab Gradient and then place a checkmark in the box titled Preset. Click on the drop down arrow and select the Daybreak from the Preset colors . Click on the OK button, but do not close the dialog box.
4. Change the chart's border by placing a checkmark in the box Round corners, and change the border's weight to a higher weight. Save the changes by clicking on the button OK.
5. Click on the label Saturday and drag the label outward. Notice that the leader line follows to the new position. Repeat the move for each label until the chart takes shape.
6. Double click on any leader line and then change the weight to the next higher weight.
7. Double click on the Chart Title. Format the title to a bold size 16 Garamond Book Condensed font.
8. Right click on the chart and choose 3-D View from the short-cut menu. Change the chart's elevation to 25 degrees in the 3-D View dialog box.
9. Click on the edge of the pie chart. Hold the Ctrl key down and drag the chart outward. Release the mouse button, notice that the pie slices moved away from the center.
10. Next, format one of the pie chart slices to a color other than one in use. Use the Fill Bucket from either the Formatting Toolbar or the Drawing Toolbar. To access the Drawing Toolbar click on the menu View | Toolbars | Drawing. Save the changes.

Printing a Chart

To print only the chart first select the chart. Next, click on the menu File | Print| Selected Chart.

 

Renaming Sheets/Adding Sheets

1. Right click on the tab of the sheet to be renamed (located on the bottom of the worksheet). Choose Rename from shortcut menu.
2. To add a worksheet you would choose Insert from the same menu. Other options include deleting the worksheet, moving the worksheet to another workbook, making a copy of the worksheet, or viewing the code.
3. To move a worksheet in a workbook click and hold the left mouse button down on the worksheet's tab. Next, drag the worksheet to the desired position and then release the mouse button. When moving the worksheet the mouse indicator displays an icon resembling a worksheet.
   
   

Search | Site Map | Ask Scranton | Choosing Scranton | My Scranton | Campus Contacts