Show All

Hide All

You can enhance a chart by inserting a picture (such as a business logo) in the chart area (chart area: The entire chart and all its elements.). Or you can use a picture fill to draw attention to specific chart elements such as the chart area, the plot area (plot area: In a 2-D chart, the area bounded by the axes, including all data series. In a 3-D chart, the area bounded by the axes, including the data series, category names, tick-mark labels, and axis titles.), the data markers (data marker: A bar, area, dot, slice, or other symbol in a chart that represents a single data point or value that originates from a worksheet cell. Related data markers in a chart constitute a data series.) (in column, bar, area, bubble, 3-D line, and filled radar charts), the legend (legend: A box that identifies the patterns or colors that are assigned to the data series or categories in a chart.) (in 2-D and 3-D charts), or the 3-D walls and floor (3-D walls and floor: The areas surrounding many 3-D chart types that give dimension and boundaries to the chart. Two walls and one floor are displayed within the plot area.) 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.

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

   

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 (sizing handle: One of the small circles or squares that appears at the corners and sides of a selected object. You drag these handles to change the size of the object.) 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.

   

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 .

   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 .

   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.

     

  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