250 likes | 414 Views
Microsoft Office 2007- Illustrated. Enhancing Charts. Objectives. Work with charts in PowerPoint Change chart design and style Customize a chart layout Format chart elements Animate a chart. Objectives. Embed an Excel chart Link an Excel worksheet Update a linked Excel worksheet.
E N D
Microsoft Office 2007- Illustrated Enhancing Charts
Objectives • Work with charts in PowerPoint • Change chart design and style • Customize a chart layout • Format chart elements • Animate a chart Microsoft Office 2007-Illustrated
Objectives • Embed an Excel chart • Link an Excel worksheet • Update a linked Excel worksheet Microsoft Office 2007-Illustrated
Working with Charts in PowerPoint • Use an Excel chart to display numerical data • Excel is fully integrated with PowerPoint and is used by default to create charts • Microsoft Graph is used to create charts when Excel is not available Microsoft Office 2007-Illustrated
Working with Charts in PowerPoint (cont.) Excel window PowerPoint window Microsoft Office 2007-Illustrated
Working with Charts in PowerPoint (cont.) • Two ways to insert an Excel chart • Embed– object created in another program, then inserted on a slide • Becomes a part of the presentation and can be opened by double-clicking • Link – object created in another program, then inserted on a slide • Is not saved with the presentation, and requires its source file to open it Microsoft Office 2007-Illustrated
Changing Chart Design and Style • Use Excel’s Chart tools to customize chart elements • Format individual chart elements or apply a predefined chart layout or style Available predefined chart layouts Microsoft Office 2007-Illustrated
Changing Chart Design and Style (cont.) Microsoft Office 2007-Illustrated
Changing Chart Design and Style (cont.) • Save a chart as a template • Save a customized chart as a template using the *.crtx file extension • Saved in the Charts Template folder • Apply the template to a future chart Microsoft Office 2007-Illustrated
Customizing a Chart Layout • Add individual elements in a chart • Change plot area color; add gridlines; format axis and axis labels • Major gridlines – identify major units on the axis, usually at a tick mark • Minor gridlines – identify minor units on the axis Microsoft Office 2007-Illustrated
Customizing a Chart Layout (cont.) Minor gridline Major gridline Microsoft Office 2007-Illustrated
Customizing a Chart Layout (cont.) • Format axis labels • Add data labels Microsoft Office 2007-Illustrated
Formatting Chart Elements • Use Quick Styles to format all of the elements of a chart • Format individual elements • Change colors, spacing, and styles Microsoft Office 2007-Illustrated
Formatting Chart Elements (cont.) New color Microsoft Office 2007-Illustrated
Animating a Chart • Animate chart elements • Make bars appear by series, groups, or individually • Animate the legend and grid • Control the order and timing of the animations • Add sound effects to the animations • Drum roll, applause, explosion Microsoft Office 2007-Illustrated
Animating Charts and Adding Sounds (cont.) Microsoft Office 2007-Illustrated
Animating Charts and Adding Sounds (cont.) • Adding voice narrations • Record a voice narration that plays with a slide show if your computer has a sound card and microphone • To record, click the Record Narration button on the Slide Show tab Microsoft Office 2007-Illustrated
Embedding an Excel Chart • Insert an existing chart into a presentation • Source Program – The program used to create an embedded object • Source File – The file where the embedded object is stored • Destination File – The file where the embedded object is inserted Microsoft Office 2007-Illustrated
Embedding an Excel Chart (cont.) Microsoft Office 2007-Illustrated
Embedding an Excel Chart (cont.) • Embed an Excel worksheet • Embed part or an entire worksheet • Click the Object button on the Insert tab • Double-click the object to edit it in Excel Microsoft Office 2007-Illustrated
Linking an Excel Worksheet • Connect an object to a presentation using a link • A link is a connection between a source file and a destination file • A linked object is stored in its source file and not in the presentation as an embedded object • Make changes using the source file and source program Microsoft Office 2007-Illustrated
Linking an Excel Worksheet (cont.) • Changes made to the linked file are reflected in the presentation • Use linking when you want the latest information to always appear in the presentation Microsoft Office 2007-Illustrated
Updating a Linked Excel Worksheet • The source file of the linked object must be available • Open the source file by double-clicking the object • Open the source file by opening the source program • The PowerPoint presentation does not have to be open Microsoft Office 2007-Illustrated
Updating a Linked Excel Worksheet (cont.) • Linking objects using Paste Special • Link objects or selected information from another program to PowerPoint • Useful when you want to link a part of a file Microsoft Office 2007-Illustrated