Use a picture in a chart

You can enhance a chart by inserting a picture (such as a business logo) in the chart area. Or you can use a picture fill to draw attention to specific chart elements such as the chart area, the plot area, the data markers (in column, bar, area, bubble, 3-D line, and filled radar charts), the legend (in 2-D and 3-D charts), or the 3-D walls and floor of a chart.

You can also copy a picture to a chart or to chart elements such as data markers in 2-D line charts, scatter charts, or an unfilled radar chart. If a picture is no longer needed, you can remove it.

What do you want to do?

Insert a picture in a chart

Fill a chart element with a picture

Copy a picture to a chart or chart element

Remove a picture from a chart

Insert a picture in a chart

  1. Click the chart area of the chart.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  2. On the Layout tab, in the Insert group, click Picture.

    Excel Ribbon Image

  3. Locate the picture that you want to insert, and then double-click it.

    Tip   To add multiple pictures, hold down CTRL while you click the pictures that you want to insert, and then click Insert.

  4. To change the size of the picture, drag a sizing handle away from or toward the center of the picture while doing one of the following:

    • To keep the center of the picture in the same place, hold down CTRL while you drag the sizing handle.

    • To maintain the proportions of the picture, hold down SHIFT while you drag the sizing handle.

    • To both keep the center of a picture in the same place and maintain its proportions, hold down CTRL+SHIFT while you drag the sizing handle.

      Tip   You can also resize a picture to an exact height and width by selecting the picture and then entering the size that you want in the Shape Height and Shape Width boxes (Format tab, Size group).

  5. To move the picture, drag it to the location that you want.

Note   Pictures that you insert in your chart are embedded in your chart and therefore increase the file size. To reduce the file size, you can link to a picture instead of inserting it. In the Insert Picture dialog box, click the picture that you want to insert, click the arrow next to Insert, and then click Link to File.

Top of Page

Fill a chart element with a picture

  1. On a chart, click the chart area, the plot area, the data marker, the legend, the 3-D wall, or the 3-D floor that you want to fill with a picture.

    This displays the Chart Tools, adding the Design, Layout, and Format tabs.

  2. On the Format tab, in the Shape Styles group, click Shape Fill.

    Shape Styles group on Excel Ribbon

  3. Click Picture.

  4. Locate the picture that you want to insert, and then double-click it.

Top of Page

Copy a picture to a chart or chart element

  1. On a worksheet or chart, select the picture that you want to copy.

  2. On the Home tab, in the Clipboard group, click Copy Button image.

    Keyboard shortcut  To copy a selection, press CTRL+C.

  3. Click the chart area or the chart element into which you want to paste the picture.

  4. On the Home tab, in the Clipboard group, click Paste Button image.

    Keyboard shortcut  To paste a selection, press CTRL+V.

Top of Page

Remove a picture from a chart

Do one of the following:

  • To remove a picture that was inserted in the chart, click that picture, and then press DELETE.

  • To remove a picture that was filled into a chart element, select that chart element, and then do the following:

    1. On the Layout tab, in the Current Selection group, click Format Selection.

      excel ribbon image

    2. Click Fill, and then under Fill, click Automatic.

      Tip   To remove the picture and any other fill effects that are applied to the selected chart element, click No Fill.

Top of Page

Applies To: Excel 2007, Outlook 2007, PowerPoint 2007, Word 2007



Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language