Insert a Picture in a Chart

1. Click the chart area of the chart.
*This displays the Chart Tools, adding the Design, Layout, and Format tabs.

2. On the Layout tab, in the Insert group, click Picture.

3. Locate the picture that you want to insert, and then double-click it.
*Tip: To add multiple pictures, hold down CTRL while you click the pictures that you want to insert, and then click Insert.

4. To change the size of the picture, drag a sizing handle (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) away from or toward the center of the picture while doing one of the following:
* To keep the center of the picture in the same place, hold down CTRL while you drag the sizing handle.
* To maintain the proportions of the picture, hold down SHIFT while you drag the sizing handle.
* To both keep the center of a picture in the same place and maintain its proportions, hold down CTRL+SHIFT while you drag the sizing handle.

Tip: You can also resize a picture to an exact height and width by selecting the picture and then entering the size that you want in the Shape Height and Shape Width boxes (Format tab, Size group).
5. To move the picture, drag it to the location that you want.

Note   Pictures that you insert in your chart are embedded in your chart and therefore increase the file size. To reduce the file size, you can link to a picture instead of inserting it. In the Insert Picture dialog box, click the picture that you want to insert, click the arrow next to Insert, and then click Link to File.

Save a Chart as a Chart Template

1. Click the chart that you want to save as a template.

Tip: This displays the Chart Tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Save As Template.

3. In the Save in box, make sure that the Charts folder is selected.

Note: The Charts folder is typically selected by default. Chart templates that you save in this folder will automatically be added to the Templates folder in the Insert Chart and Change Chart Type dialog box so that you can select it when you create or update a chart.

4. In the File name box, type an appropriate name for the chart template.

Microsoft Word 2007: Change the author name for documents
Every time you create a new document, Microsoft Office Word sets the Author property based on the User name setting that appears in the Word Options dialog box. The User name setting also provides the name and initials that are displayed in comments and tracked changes.
Change the author name in an existing document
1. Click the Microsoft Office Button Button point to Prepare, and then click Properties.
2. In the Document Information Panel, type the author name in the Author box.
Note: Changing the Author property in the Document Information Panel of an existing document has no effect on the User name setting in the Word Options dialog box.

Microsoft Outlook 2007: Preview attachments

When you receive an attachment in a message and want to quickly see what the attachment contains without opening it, you can preview the attachment in the Reading Pane (Reading Pane: A window in Outlook where you can preview an item without opening it. To display the item in the Reading Pane, click the item.) or in an open message. Attachment Preview, a new feature in the 2007 Microsoft Office system, allows you to preview some attachment file types without opening them. Messages that have attachments are identified by a paper clip icon in the message list.

You can preview an attachment in the Reading Pane or from within an open message. The attachment previewers that come with the 2007 Office release are on by default.

* Note: To preview an attached file created in an 2007 Microsoft Office system application, you must have that 2007 Office application installed on your computer. For example to preview a Word attachment, you must have Word installed. To preview an Excel attachment, you must have Excel installed.

Preview an attachment in an open message

1. Open the message that has the attachment. Messages that have attachments are identified by a paper clip icon in the message list.
2. In the open message, click the attachment to preview it.
3. To return to the message body, click the Message button.

Preview an attachment in the Reading Pane

1. In the message list, select the message that has the attachment that you want to preview.
2. In the Reading Pane, click the attachment. If there are multiple attachments, you may need to scroll horizontally to find the attachment that you want.
*Note: A preview might not show the most up-to-date content in the file. To see the most complete, up-to-date content, open the file. For example, you can double-click a .docx attachment to open it in Microsoft Word.
3. To return to the message body, click the Message button.

Microsoft Excel 2007: Clear a filter for a column.

To clear a filter for one column in a multicolumn range of cells or table, click the Filter button on the heading, and then click Clear Filter from <Column Name>.

Change the appearance of your e-mail message

Add a background color, gradient, texture, pattern, or picture

1. On the Message Options tab, in the Themes group, click Page Color.
2. Click a color on the Theme Colors or Standard Colors palette. To remove the color, click No Color.
3. If you want to add a gradient, texture, pattern, or picture, click Fill Effects.
4. Select the fill options that you want.

Tip: The color of the gradient, texture, or pattern is based on the color that you select in step 2.

Log On To Learn presents: Introduction to Google Drawing.  A four-minute video tutorial available to you at no charge on You Tube.

Subscribe to our You Tube channel for our continuous video additions on Google Apps and much more.  Go to http://www.youtube.com/user/LogOnToLearn and subscribe today. 

Introduction to Google Drawing

Product(s): Google Apps
Audience(s): Business Professional.
Duration: 04:02

Event Overview:
New to Google Drawing? Watch this video to learn the basic functions!

Change the Chart Type of an Existing Chart

For most 2-D charts, you can change the chart type of the whole chart to give the chart a different look, or you can select a different chart type for any single data series (data series: Related data points that are plotted in a chart. Each data series in a chart has a unique color or pattern and is represented in the chart legend. You can plot one or more data series in a chart. Pie charts have only one data series.), which turns the chart into a combination chart.
For bubble charts and most 3-D charts, you can only change the chart type of the whole chart.

NOTE:   To complete this procedure, you must have an existing chart. For more information about how to create a chart, see Create a chart.

1. Do one of the following:
* To change the chart type of the whole chart, click the chart area (chart area: The entire chart and all its elements.) or plot area (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.) of the chart to display the chart tools.
* To change the chart type of a data series, click that data series.

NOTE:    You can change the chart type of only one data series at a time. To change the chart type of more than one data series in the chart, repeat the steps of this procedure for each data series that you want to change.

Tip:   This displays the chart tools, adding the Design, Layout, and Format tabs.
2. On the Design tab, in the Type group, click Change Chart Type.
3. In the Change Chart Type dialog box, do one of the following:
* Click a chart type in the first box, and then click the chart subtype that you want to use in the second box.
* If you saved a chart type as a template, click Templates, and then click the chart template that you want to use in the second box.
Tip: If you use a specific chart type frequently when you create a chart, you may want to set that chart type as the default chart type. After you select the chart type and the chart subtype in the Change Chart Type dialog box, click Set as Default Chart.

Rename a PivotTable or PivotChart Report

When you create a PivotTable or PivotChart report, Microsoft Office Excel assigns default names to each of these objects by using the following naming conventions: PivotTable1, PivotTable2, and so on; and Chart 1, Chart 2, and so on. However, you can change the name of each object to make it more meaningful to you.

PivotTable report

1. Click the PivotTable report.
2. On the Options tab, in the PivotTable group, click the PivotTable Name text box.
3. Type a new name.
4. Press ENTER.

PivotChart report

1. Click the PivotChart report.
2. On the Layout tab, in the Properties group, click the Chart Name text box.
3. Type a new name.
4. Press ENTER.

Microsoft Word 2007: Prevent page breaks in the middle of a paragraph

1. Select the paragraph that you want to prevent from breaking onto two pages.
2. On the Page Layout tab, click the Paragraph Dialog Box Launcher, and then click the Line and Page Breaks tab.
3. Select the Keep lines together check box.