Outlook 2007
Home Up TN 2010 Outlook 2010 Word 2007 Word 2010 PPT 2007 PPT 2010 Windows 7 Vista Excel 2007-10 Access 2007 About Us

Insert a Chart

  1. Open new message in outlook / click in the space to insert the chart
  2. Go to Insert tab / Illustrations group / Chart
  3. Click the type of chart you want / OK
  4. Office Excel 2007 opens in a split window and displays sample data on a worksheet.

    Sample data for chart
     

  5. In Excel, replace the sample data by clicking a cell on the worksheet and then typing the data that you want.

    You can also replace the sample axis labels in Column A and the legend entry name in Row 1.

    After you update the worksheet, the chart in Outlook will be updated automatically with the new data.

  6. In Excel, click Microsoft Office ButtonButton image /Click Save As
  7. Select the folder or drive that you want to save the worksheet to.
    Tip 
      To save the worksheet to a new folder, click Create New Folder Button image .
  8. In the File name box, type a new name for the file.
  9. Select Type: Excel 97-2003 Workbook
  10. Click Save
  11. In Excel, click the Microsoft Office ButtonButton image, and then click Close.

The next time you want to use this chart

Open Outlook program
New e-mail / Insert Tables group / Click Table diamond

Select Excel Spreadsheet
Select drive / folder / Highlight file / Open

Make any corrections to the spreadsheet / Save


Created:  July 05, 2012

Sr. Arlene Callahan
Training Manager
Rivier University
Nashua, NH 03060

E-mail: acallahan@rivier.edu