Excel 2007 Graphics allows you to add graphics of many different types to your worksheets.
Inserting a Shape in Excel 2007
Basic shapes are inserted using the Illustrations group of the Insert tab. Basic shapes include: circles, rectangles, arrows and basic callouts.
To insert a shape into the Excel 2007 worksheet,
Click the Shapes dropdown in the Illustrations group of the Insert tab.
The Shapes Gallery opens.
Click the desired shape.
Click in the worksheet and drag the shape to the desired size and location. NOTE: Hold down Shift while clicking and dragging to constrain your shape (i.e., create a perfect circle or square).
The shape inserts into the worksheet.
Inserting a Picture
Pictures are inserted using the Illustrations group of the Insert tab. Pictures are generally photographs, and include .jpg, and .bmp file types. Pictures can be retrieved from any location on your computer.
To insert a picture into the worksheet,
Click the Picture button in the Illustrations group of the Insert tab.
Browse to the location of the picture to insert.
The selected picture inserts into the worksheet.
ClipArt is inserted using the Illustrations group on the Insert tab. ClipArt is any predefined image. The ClipArt used in Excel is generally created by Microsoft.
To insert ClipArt into the worksheet,
Click the ClipArt button in the Illustrations group of the Insert tab.
The ClipArt task pane opens.
Type a search term in the Search for field. In the example below, well use technology as our
Click on an appropriate image from the search results. The ClipArt inserts into the
Inserting a SmartArt Graphic
SmartArt is inserted using the Illustrations group of the Insert tab. SmartArt is a visual representation of textual data.
Inserting the SmartArt Graphic
To insert a SmartArt Graphic,
Click the SmartArt button in the Illustrations group of the Insert tab.
The Choose SmartArt Graphic screen opens.
Select the desired SmartArt using the categories and palette. Note the descriptions of each in the right-hand pane.
In the example below, we will insert the Vertical Chevron List from the List category.
Click OK to insert the graphic.
Editing the SmartArt Graphic
The SmartArt is inserted with placeholder text. We need to customize it to include our information.
We want to insert sales quarterly sales for each of our salespersons. To do this, type the following information into the Type your text here section of the screen.
The SmartArt should look like this:
To add a bullet, press Enter in the bullet above.
To demote a bullet, press Tab.
To promote a bullet, press Shift + Tab.
Use the vertical scrollbar to access bullets below or above.
When you are finished entering all of the text, close the Type your text here screen. Your SmartArt should look like this.
Notice that Excel automatically resizes the components of the graphic to hold your text.
Inserting a Text Box
Text boxes are inserted using the Text group of the Insert tab. Text boxes are standalone areas containing text. They can be formatted and moved separately from data in the worksheet.
To insert a text box,
Click the Text Box button in the Text group of the Insert tab.
Click and drag to draw the text box in the desired location. Once you release the mouse button, the cursor will be blinking in the text box.
Type your desired text.
WordArt is inserted using the Text group of the Insert tab. WordArt displays text in a highly formatted manner.
To insert WordArt,
Click the WordArt dropdown in the Text group of the Insert tab.
The WordArt pallet opens.
Click one of the styles. A text box containing placeholder text opens.
Click in the text box and type your desired text. Your text displays as WordArt.
To select an object, click on the object. Youll notice a border around the object once it is active.
Resizing a Graphic Object
To resize a graphic object,
Click the object to activate it.
Click one of the handles and drag the object to the desired size.
Notice that your cursor
changes when hovering over a handle.
Alternately, the Height, Width and Crop commands in the Size group of the Picture Tools/Drawing Tools Format tab can be used to resize the object.
Handles at the corners resize the object proportionally.
Handles on the top and bottom resize the object vertically or horizontally. This can distort the object.
Reshaping a Graphic Object
To reshape a graphic object,
Click on the graphic object to activate it.
Click Edit Shape Change Shape in the Insert Shapes group of the Drawing Tools
Select the shape you wish to change to from the pallet.
The shape changes.
Moving a Graphic Object
To move a graphic object,
Click on the object to activate it.
Notice that your cursor changes when hovering over the object.
Drag the object to its new location.
Aligning a Graphic Object
When two or more objects are used in a worksheet, they can be aligned in several ways.
To align graphic objects,
Select the objects to align, holding down Shift or Ctrl to select multiple objects.
Click the Align dropdown in the Arrange group of the Drawing Tools or Picture Tools
Format tabs. The alignment pallet opens.
Choose the desired alignment from the list. The objects align. Align Middle is used in the image below.
Copying a Graphic Object
Objects can be copied in three ways
Click the object to copy.
Click the Copy button in the Clipboard group of the Home tab. The object is copied.
Right-click the object to copy.
Select Copy. The object is copied.
Ctrl + Click and Drag
Click the object to be copied.
Hold down Ctrl and drag the object. The object is copied.
Deleting a Graphic Object
To delete an object, click the object and press Delete.
Grouping Graphic Objects
To group objects,
Select the objects to group, holding down Shift or Ctrl to select multiple objects.
Click Group from the Group dropdown in the Arrange group of the Drawing Tools or Picture Tools Format tabs.
The objects are grouped and can now be moved as a single item.
To ungroup objects,
Select the group to ungroup.
Click Ungroup from the Group dropdown in the Arrange group of the Drawing Tools or Picture Tools Format tabs.
The objects are ungrouped.
Stacking Graphic Objects
Objects can be layered or stacked in Excel. They can be moved backwards or forwards in layers, or can be sent all the way to the back or front of the stack.
Lets suppose you have an image of an arrow that you would like to appear in front of a circle.
To stack the objects so that the arrow is in front of the circle,
Click the arrow.
Click Bring to Front in the Arrange group of the Drawing Tools Format tab.
Drag the arrow on top of the circle.
Use the options available in the Arrange group to stack or layer objects as desired.
Formatting the Fill of a Graphic Object
To change the fill of an object,
Click the object.
Click the Shape Fill dropdown in the Shape Styles group of the Drawing Tools or Picture
Tools Format tab.
Choose the desired fill. The objects fill changes.
Formatting the Outline of a Graphic Object
To change the outline of an object,
Click the object.
Click the Shape Outline dropdown in the Shape Styles group.
Choose the desired outline. The objects outline changes.
This Audacity tutorial will show you how to use the basic tools and procedures in the open source audio editing program, Audacity. Not just screen shots, but free narrated multimedia tutorials - You'll learn to use Audacity for recording and editing audio files that can be used for podcasting, mixing music and vocals, creating sound tracks, and other audio projects.
This Excel 2003 Tutorial will introduce you to the basics of using the Excel 2003 spreadsheet program. You'll learn to create a spreadsheet, basic Excel workbook skills, work with cells, enter and manipulate data, apply formulas, format data, create and work with charts, and manage Excel workbooks.
This Podcasting tutorial includes a step by step guide that will show you how to record, publish and promote your podcast. Using inexpensive equipment and free software, you'll be publishing podcasts in no time.
This LCD Projector Guide will assist you in the use and purchase of a digital LCD projector or DLP projector. It will discuss the differences between LCD and DLP projectors, size and portability considerations, lamp types and brightness, resolution, image quality and other considerations in the use and purchase of a digital projector.
This Microsoft Word 2007 Workspace tutorial will acquaint you with the new tools and features in the Word 2007 Window. It's changed significantly from previus versions and even experienced users will find this helpful.
Get the Excel 2007 Ebook: The Ultimate Guide and receive all of the Excel 2007 tutorials in one handy reference guide. Purchase online easily with your credit card or PayPal and have the Ebook emailed to your email address (pdf format)
Price: $12.95. California residents pay 7.25% Sales tax. Delivered via email.