Charts in Excel

Tom Kelliher, CS 102

May. 3, 2004

Administrivia

Announcements

Course evaluation.

Web sites due now!

Assignment

From Last Time

Lab day for Web sites.

Outline

  1. Loan payments in Excel.

  2. Charts in Excel.

  3. Exercise.

Coming Up

Charts

  1. ``A picture is worth 1,000 words.''

    What is the purpose of a chart?

  2. Types of charts: bar, column, pie, line.

    Variants: ``graduated'' bar chart.

    How do you decide what chart to use?

    Examples from the budget spreadsheet.

  3. Demonstration: Chart Wizard.

    Outline of steps:

    1. Select ranges: numbers/formulas and labels.

    2. Click Chart Wizard button (looks like a column chart).

    3. Choose chart type.

    4. Add title, legends, other info.

    5. Insert into spreadsheet as object. Adjust position and size as necessary.

  4. Selecting disjoint ranges.

Use budget.xls for demo.

Inserting a ``Live'' Chart into a Document

The ``big'' picture:

What if the numbers change? Will we have to re-insert the updated chart?

Not if we've inserted a link! Steps:

  1. To begin with, start with a chart that's embedded on a spreadsheet page --- not a ``separate sheet'' chart.

  2. In Excel: Select chart, open Edit menu, and choose Copy.

  3. In Word: Position insertion point in document where you want chart to appear, open Edit menu, and choose Paste Special. Select radio buttons for Paste Link.

  4. Adjust positioning and size of chart as necessary.

Demonstrate with class, using budget.xls.

Excel Exercise

Follow the lab. Also, practice creating a chart or two.



Thomas P. Kelliher
Thu Apr 29 15:53:16 EDT 2004
Tom Kelliher