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.

   
    

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 Button /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 .
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 Button, 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