Excel 2007 Graphics

This tutorial explains how to work with Excel 2007 Graphics

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,

  1. Click the Shapes dropdown in the Illustrations group of the Insert tab.

    WorkingWithGraphics_1

    The Shapes Gallery opens.

    WorkingWithGraphics_2

  2. Click the desired shape.
  3. 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.

    WorkingWithGraphics_3

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,

  1. Click the Picture button in the Illustrations group of the Insert tab.


    WorkingWithGraphics_4


  2. Browse to the location of the picture to insert.


    WorkingWithGraphics_5

  3. Click Insert.
  4. The selected picture inserts into the worksheet.


    WorkingWithGraphics_6

Inserting ClipArt

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,

  1. Click the ClipArt button in the Illustrations group of the Insert tab.


    WorkingWithGraphics_7


    The ClipArt task pane opens.
  2. Type a search term in the Search for field. In the example below, we’ll use technology as our
    search term.


    WorkingWithGraphics_8


  3. Click Go.
  4. Click on an appropriate image from the search results. The ClipArt inserts into the
    worksheet

    .
    WorkingWithGraphics_9

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,

  1. Click the SmartArt button in the Illustrations group of the Insert tab.


    WorkingWithGraphics_10


    The Choose SmartArt Graphic screen opens.


    WorkingWithGraphics_11


  2. 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.
  3. Click OK to insert the graphic.


    WorkingWithGraphics_12

    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.

    WorkingWithGraphics_13


    The SmartArt should look like this:


    WorkingWithGraphics_14


    • 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.


WorkingWithGraphics_15

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,

  1. Click the Text Box button in the Text group of the Insert tab.


    WorkingWithGraphics_16


  2. 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.
  3. Type your desired text.

Inserting WordArt

WordArt is inserted using the Text group of the Insert tab. WordArt displays text in a highly formatted manner.

To insert WordArt,

  1. Click the WordArt dropdown in the Text group of the Insert tab.


    WorkingWithGraphics_17


    The WordArt pallet opens.


    WorkingWithGraphics_18


  2. Click one of the styles. A text box containing placeholder text opens.
  3. Click in the text box and type your desired text. Your text displays as WordArt.


    WorkingWithGraphics_19
  • Selecting Objects

    To select an object, click on the object. You’ll notice a border around the object once it is active.


    WorkingWithGraphics_20

    Resizing a Graphic Object

    To resize a graphic object,

    1. Click the object to activate it.
    2. Click one of the handles and drag the object to the desired size.
      Notice that your cursor
      changes when hovering over a handle.


      WorkingWithGraphics_21

    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,

    1. Click on the graphic object to activate it.


      WorkingWithGraphics_22


    2. Click Edit Shape – Change Shape in the Insert Shapes group of the Drawing Tools

      Format
      tab.


      WorkingWithGraphics_23

    3. Select the shape you wish to change to from the pallet.
      The shape changes.


      WorkingWithGraphics_24

    Moving a Graphic Object

    To move a graphic object,

    1. Click on the object to activate it.
    2. Notice that your cursor changes when hovering over the object.


      WorkingWithGraphics_25


    3. 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,

    1. Select the objects to align, holding down Shift or Ctrl to select multiple objects.


      WorkingWithGraphics_26


    2. Click the Align dropdown in the Arrange group of the Drawing Tools or Picture Tools
      Format
      tabs. The alignment pallet opens.


      WorkingWithGraphics_27


    3. Choose the desired alignment from the list. The objects align. Align Middle is used in the image below.


      WorkingWithGraphics_28

    Copying a Graphic Object

    Objects can be copied in three ways

    Home Tab

    1. Click the object to copy.
    2. Click the Copy button in the Clipboard group of the Home tab. The object is copied.

    Right-click

    1. Right-click the object to copy.
    2. Select Copy. The object is copied.

    Ctrl + Click and Drag

    1. Click the object to be copied.
    2. Press Ctrl.
    3. 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,

    1. Select the objects to group, holding down Shift or Ctrl to select multiple objects.
    2. Click Group from the Group dropdown in the Arrange group of the Drawing Tools or
      Picture Tools Format tabs.


      WorkingWithGraphics_29


      The objects are grouped and can now be moved as a single item.

    To ungroup objects,

    1. Select the group to ungroup.
    2. Click Ungroup from the Group dropdown in the Arrange group of the Drawing Tools or Picture Tools Format tabs.


      WorkingWithGraphics_30


      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.

    Let’s suppose you have an image of an arrow that you would like to appear in front of a circle.

    WorkingWithGraphics_31

    To stack the objects so that the arrow is in front of the circle,

    1. Click the arrow.
    2. Click Bring to Front in the Arrange group of the Drawing Tools Format tab.
    3. Drag the arrow on top of the circle.


      WorkingWithGraphics_32


      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,

    1. Click the object.
    2. Click the Shape Fill dropdown in the Shape Styles group of the Drawing Tools or Picture
      Tools Format
      tab.


      WorkingWithGraphics_33



    3. Choose the desired fill. The object’s fill changes.


      WorkingWithGraphics_34

    Formatting the Outline of a Graphic Object

    To change the outline of an object,

    1. Click the object.
    2. Click the Shape Outline dropdown in the Shape Styles group.


      WorkingWithGraphics_35


      Choose the desired outline. The object’s outline changes.


      WorkingWithGraphics_36

    How to Link to This Page

    It will appear on your page as: Excel 2007 Graphics

     


    Search for Tutorials
     

    Excel Tutorials: Excel 2007 Tutorials

    Excel 2007 Tutorials
    Excel 2007 Charts
    Excel 2007 Graphics
    Excel 2007 Worksheets
    Excel 2007 Worksheet Views
    Excel 2007 Formulas
    Excel 2007 Named Ranges
    Excel 2007 Cell Comments

    Excel Video Tutorials
    Lesson 1: Excel Basics
    Lesson 2: Editing a Worksheet
    Lesson 3: Making Bar and Circle Graphs
    Lesson 4: Making a Gantt Chart
    Lesson 5: Excel Keyboard Shortcuts

    More Excel Tutorials at GuidesandTutorials.net

    All Other Guides and Tutorials

    Guides and Tutorials Blog
    Listing of the latest tutorials published on the GuidesandTutorials website.
    GuidesandTutorials: Audacity Tutorial - Record and Edit Audio
    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.
    Audacity Tips & Tricks
    Audacity tips and tricks submitted by users
    Digital Photography Guide
    This Digital Photography Guide will provide you with the basic information you need to take professional quality photogrphs with your digital camera.
    GuidesandTutorials: Dreamweaver Tutorial
    Dreamweaver Tutorial - this series of free Dreamweaver tutorials is just what you need to get up and running with Dreamweaver to create interesting and compelling web sites
    GuidesandTutorials: Microsoft Excel 2003 Tutorial
    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.
    Podcasting Tutorial
    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.
    PowerPoint Tutorial - Microsoft PowerPoint 2003
    This PowerPoint tutorial is just what you need to learn how to use PowerPoint 2003 to create effective and engaging presentations.
    The PowerPoint 2007 Window
    This PowerPoint 2007 tutorial will show you the features and how to get around the PowerPoint Window.
    GuidesandTutorials: Free PowerPoint Templates
    Free PowerPoint templates that you can download and use today. This is a growing library of free resources for PowerPoint users.
    LCD Projector Guide and Tutorial
    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.
    Word Tutorial: Microsoft Word 2003
    This Word tutorial is just what you need to learn how to use Word 2003 to create professional looking documents.
    Word 2007 Workspace
    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.
    Work at Home Jobs
    This Work at Home Jobs tutorial will provide information on ways that you can put your skills and knowledge to use in creating part or full time income while working from home.
    Guides and Tutorials: Free Guides and Tutoials Site Map
    Free guides and tutorials on podcasting, digital video and audio, Audacity, RSS, multimedia development, educational technology, technology integration, K12 Technology, PowerPoint.
    Suggest a New Technology Tutorial
    Free Technology Tutorials on software and technology applications including PowerPoint tutorials, Podcasting tutorials, Dreamweaver tutorials, Audacity, Non-Linear PowerPoint, Digital Photography, RSS tutorial, and everything educational technology.
    Adobe Acrobat 9 Tutorial
    This Adobe Acrobat 9 Tutorial will show you how to create PDFs from MS Office applications, from Multipe files, from web pages and from several other types of documents.
    GuidesandTutorials: Free Tutorials
    Free Tutorials, software, hardware, and technology applications including PowerPoint, Podcasting, Dreamweaver, Audacity,
    Excel 2007 Tutorial | GuidesandTutorials: Free Tutorials
    This free Excel 2007 Tutorial will show you how to use all of the begginer and intermediate features in Excel 2007

    This site proudly build with Site Build It!

    Powered By SiteBuildIt

    .

  • Excel 2007 Ebook: The Ultimate Guide - $12.95

    Excel 2007 Ebook

    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.

    Excel Video Tutorials
    1. Excel Basics
    2. Editing a Worksheet
    3. Making a Gantt Chart
    5. Excel Keyboard Shortcuts

    Excel 2007 Tutorials
    Excel 2007 Charts
    Excel 2007 Graphics
    Excel 2007 Worksheets
    Excel 2007 Worksheet Views
    Excel 2007 Formulas
    Excel 2007 Named Ranges
    Excel 2007 Cell Comments

    More Excel Tutorials at
    GuidesandTutorials.net

    [?] Subscribe To This Site

    XML RSS
    follow us in feedly
    Add to My Yahoo!
    Add to My MSN
    Subscribe with Bloglines