Skip to Content
Excel® 2010 Workbook for Dummies®
book

Excel® 2010 Workbook for Dummies®

by Greg Harvey
September 2010
Beginner
408 pages
10h 23m
English
For Dummies
Content preview from Excel® 2010 Workbook for Dummies®

Chapter 16. Adding Graphics to Spreadsheets

In This Chapter

  • Understanding what graphic objects are and how Excel treats them

  • Adding clip art to the spreadsheet

  • Importing graphics files into the spreadsheet

  • Adding graphic shapes and text boxes to the spreadsheet

  • Constructing WordArt, organizational charts, and other diagrams

As you discovered in Chapter 15, the embedded charts you add to a spreadsheet are actually graphic objects that you can move and resize as needed. Embedded charts are by no means the only graphic objects you can have in your worksheet. Excel also enables you to add graphic objects you create yourself as well as those you import from Clip Art and other kinds of graphics files.

In this chapter, you get a chance to practice using all these different types of graphic objects to improve the overall look of your spreadsheets and make their data and charts even more interesting and legible to the user.

Understanding Graphic Objects

The most important thing to remember about graphic objects is that they are distinct objects separate from the cells of the worksheet that float above on their own layers. Because they are distinct objects, you can select them for moving and resizing as you did your embedded chart in Exercise 15-1 in Chapter 15. Because graphic objects remain on separate layers, you can move them one on top of the other, with the object on the topmost layer obscuring parts of the objects on layers below.

To select a graphic object, you must click some part of it (which ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Using Microsoft® Excel® 2010

Using Microsoft® Excel® 2010

Tracy Syrstad, Bill Jelen
Microsoft® Excel 2010 On Demand

Microsoft® Excel 2010 On Demand

Steve Johnson - Perspection Inc.

Publisher Resources

ISBN: 9780470489604Purchase book