Inserting a Diagram
Diagrams
are ideal when you need to integrate and communicate a workflow,
process, or other conceptual paradigms with your spreadsheet data. You
can insert the diagram and then add the appropriate information in a
manner similar to inserting an organization chart.
1. On the Insert tab click the SmartArt button to display the SmartArt Gallery dialog box.
2. Double-click the desired diagram type; a diagram of that type containing dummy text is inserted into your worksheet.
3. Click each instance of dummy text and type over it with text of your own.
Tip: Make Use of the Layout Gallery
After your diagram is
in place, use the Layout gallery under the Design tab to try out
different layouts. Excel keeps all your text and settings but shows
your diagram in a different layout. Often times, you’ll find one that
better illustrates your message than the one you originally selected. |
Inserting an Object
You can also insert objects that
aren’t as commonly added to Excel worksheets. For example, you can
insert a media clip, PowerPoint slide, Microsoft Works chart, video
clip, and much more.
1. On the Insert tab click the Insert Object button to open the Object dialog box.
2. Scroll through the Object type list, and double-click the object you
want to insert—for example, Microsoft Office Word Document.
3. Edit the object according to the individual object properties (in this example, as you would when creating a Word document).
Note: Getting to the Object Properties
| Once your object is on your
spreadsheet, you can edit the object by right-clicking it and selecting
Document Object. This brings up a Properties menu of sorts. Here, you
can Edit the object source, Open the object itself, or convert the
object so that it is displayed as an icon. |
