Use a picture in a chart

You can add a picture to a chart by inserting it in the chart area (chart area: The entire chart and all its elements.), or by filling it into 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.), 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 chart elements such as 2-D line, xy (scatter), or unfilled radar chart data markers. And if a picture is no longer needed, you can remove it.

What do you want to do?


Insert a picture

  1. On a chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) or in an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), click the chart area.
  2. Point to Picture on the Insert menu, and then click the command that you want to use.
    • If you click Clip Art, use the Task pane to search for pictures, and then double-click the picture that you want to use.
    • If you click From File, click the drive, folder, or Internet location that contains the picture in the Look in box, and then double-click the picture that you want to use.

 Tip   After you insert a picture, you can crop or size it for a better fit in the chart. Select the picture, and then click Picture on the Format menu. On the Size, Picture, and Properties tabs, select the options that you want. You can also move the picture by dragging it to the location that you want.

Top of Page Top of Page

Use fill effects to include a picture

  1. On a chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) or in an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), double-click the chart area, the plot area, the data marker, the legend, or the 3-D wall or floor that you want to fill with a picture.
  2. On the Patterns tab, under Area, click Fill Effects.
  3. On the Picture tab, click Select Picture.
  4. In the Look in box, click the drive, folder, or Internet location that contains the picture, and then double-click the picture that you want.
  5. On the Picture tab, select the options that you want, and then click OK.

Top of Page Top of Page

Copy a picture to a chart

  1. Select the picture on the worksheet, chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.), or in a picture editing program.
  2. On the Edit menu, click Copy.
  3. Click the data series.
  4. On the Edit menu, click Paste.

Top of Page Top of Page

Remove a picture

  1. On a chart sheet (chart sheet: A sheet in a workbook that contains only a chart. A chart sheet is beneficial when you want to view a chart or a PivotChart report separately from worksheet data or a PivotTable report.) or in an embedded chart (embedded chart: A chart that is placed on a worksheet rather than on a separate chart sheet. Embedded charts are beneficial when you want to view or print a chart or a PivotChart report with its source data or other information in a worksheet.), double-click the chart element that you want to remove.
  2. On the Patterns tab, do one of the following:
    • To clear the picture or fill effect and return the object to the default formatting, click Automatic under Area.
    • To clear all formatting, including the picture or fill effect, click None under Area.

Top of Page Top of Page

 
 
Applies to:
Excel 2003