Excel 2000 Module 5


Charts can summarize, highlight, or reveal trends in your data that might not be obvious when looking at the raw numbers.



  • Creating Charts using the Chart Wizard
    Excel Chart using chart wizard - a step-by-step set of dialog box that guide you through the creation of a chart. To start, you select the type of chart you want - Excel offers 14 types, with each type having two or more subtypes.

Step 1 :

Step 2 :

Step 3 :

Step 4 :


Click <File>, <New>

Click <Sheet1>

Rename <Sheet1> to <M5Ex>


Range A2:F6

Click <Chart Wizard> button

The Step 1 of 4 - Chart Type dialog box appears
Select <Chart Type list Column>
Click <Stacked Column sub-type>

Click <Next>

The Step 2 of 4 - Chart source Data dialog box appears with a preview of your chart

Click <Next>

The Step 3 of 4 - Chart Options dialog box appears
Type at <Chart title:> Yearly Sales

Click <Next>

The Step 4 of 4 - Chart Location dialog box appears

Click <Finish>

The Chart appears in the worksheet as indicated by your Selection in As Object in option

  • Moving, Resizing, and Deleting Charts
    Once a chart is created, you can position it where you want in the worksheet, change its size, or delete it altogether.
    To move, resizes, or delete a chart, you must select the chart by clicking in the Chart Area.

    Chart Area

    Resizing, Moving (Drag-and-drop)

  • Modifying Chart Titles and Adding Axis Labels
    When you create a chart using the Chart Wizard, besides the Chart Title, you can include the necessary information by changing the chart options later.

    Chart Area
    Right-click, Click Chart Options
    Type at <Chart title:> Five-Year Revenue Projection
    Type at <Category (X) axis:> Fiscal Year
    Type at <Value (Y) axis:> Revenue (in thousands)

    Click Chart Title
    Right-click, Click Format Chart Title
    Click <Font> tab
    Click at <Size> 12

    Click <OK>

  • Moving and Formatting Chart Elements
    To emphasize certain values, you can add labels to each data point on a chart.

    Chart Legend
    Drag to the lower left corner of the Chart Area

    Right-click Chart Legend
    Click <Patterns> tab
    Select <Shadow> box Click <OK>

  • Adding Gridlines and Arrows
    Horizontal and vertical gridlines can help identify the value of each data marker in the chart. Arrows can be used to highligh a particular data marker or call attention to certain information in a chart.

    Chart Area
    Right-click, Click Chart Options
    Click <Gridlines> tab
    Select Major gridlines check box
    Minor gridlines check box

Drawing Tools :

Menu, Point and click <View><Toolbars> : click Drawing

Click <Arrow> button, point to the highest chart, point and click away from the chart

Click <Text Box> button, point to the arrow, point and drag a rectangular box
Type Largest Projected Increase

  • Previewing and Printing a Chart
    The Print Preview command displays the chart just as it will be printed, allowing you to verify the appearance and layout of your chart before printing.

    Print Preview for previewing any Windows 2000 document using the WYSIWYG (pronounced wizzy-wig) as an acronym for What You See Is What You Get, the concept that your screen shows your output as it will look on paper : change most print settings such as Set Margins, Print Area and Print Order, preview the data, and print the worksheet.

    <Print Preview> button

    The worksheet and embedded chart appear in the Preview window.
    Click <Zoom>

    Printer subsystem is the Windows printer interface for direct printed output for all your Windows programs. Click <Print>
    Menu, Point and click <File>: click

Click <Close> Print Preview

  • Changing the Chart type and Organizing the Source Data
    Excel offers a wide variety of chart types because each type emphasizes a particular aspect of the source data - being organized in rows or columns.

    Chart Area

    Click Chart Type
    Click at Standard Types Click Area
    Stacked Area

    Click <OK>

    Click Chart Area
    Click Source Data
    Click <Data Range> tab
    Click at <Series in:> for <Rows>

    Click <OK>


Click <File> <Save>

Click <File> <Close>




Practice Exercise 1 : M5: Page 16


Rename <Sheet2> to <M5Ex1>

Create the chart





Edwin Koh : We completed on the New Knowledge and Skills in
Excel 2000 Module 5.






Next Modules

6 : Printing
7 : Data Management

8 : Optional (Others)



Previous Modules

1 : Introduction
2 : Excel Basic
3 : Formulas & Functions

4 : Formatting Spreadsheet



Edwin Koh InfoTech Learning