Software

Use pictures to highlight data points in an Excel 2007 chart

Excel 2007 lets you highlight a particular data point in a chart simply by pasting a picture on the data point. Mary Ann Richardson shows how you can add visual appeal while highlighting key data.

Excel 2007 lets you highlight a particular data point in a chart simply by pasting a picture on the data point. For example, suppose you want to highlight the support center with the highest ranking to date. After you create a line chart that charts each center and its corresponding customer satisfaction rating, follow these steps:

  1. Click the Insert tab.
  2. Select Clip Art.
  3. In the Clip Art Task pane, enter People in the Search For box.
  4. Click Go.
  5. Scroll to and click the Businesswoman clip art arrow and select Copy.
  6. Right-click any cell outside of your chart and select Paste.
  7. Resize the clip to about 1/2 inch square.
  8. Right-click the resized clip and select Cut.
  9. Click on your chart.
  10. Click on the Data Series line and then click on the highest customer satisfaction data point.
  11. Press [Ctrl]V.

Now the clip art pasted on the chart's data point emphasizes the center with the top customer satisfaction rating.

Miss an Excel tip?

Check out the Microsoft Excel archive, and catch up on other Excel tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.

6 comments
mitja.lasic
mitja.lasic

It also works in Excel 2003. But how to remove such clip (or picture)?

grammybanshee
grammybanshee

Yeah, cute. However, in 2007 they took away the useful black and white textured fills such as the dots, hashmarks, etc.

mcphersonblaire
mcphersonblaire

Ditto Althea's comment: Image needed, or I have no idea why I'd want to do this. Thanks.

kprice122
kprice122

what about using an image to display the data in a graph?

Data Nut
Data Nut

Sounds great, but is it possible to add some pics to the article to illustrate this idea? A picture is worth 1000 words...

collinsb
collinsb

I have to agree with Blaire but if screenshots showing the before and after had been included, I might have seen the supposed usefulness of this tip.

Editor's Picks