Creating picture charts

Excel 2016 2013 2010 2007 2003
Excel makes it easy to incorporate a pattern, texture, or graphic file for elements in your chart. E.g., you can create a funny burger sales chart for your colleagues.
The picture Chart in Excel 365     The picture Chart in Excel 365

To convert a data series to pictures, follow these steps:

   1.   Start with a column or bar chart (either standard or 3-D):

On the Insert tab, in the Charts group, click the Insert Bar or Column Chart button:

Column Charts in Excel 365

Choose the chart you prefer.

   2.   Select the data series, then do one of the following:

  • Right-click in the data series and choose Format Data Series... in the popup menu:
    Format data series in popup menu Excel 365
  • Excel displays the Chart Design and Format tabs.

    On the Chart Format tab, in the Current Selection group, click the Format Selection icon:

    Format Selection in Excel 365

   3.   On the Format Data Series pane, in the Fill group:

  • Choose Picture or texture fill,
  • Click on the Insert... button:
    Fill Data Label in Excel 365
  • In the Insert Pictures dialog box, choose the picture location, select the picture file, and then click Open or Insert:
    Insert pictures in Excel 365
  • You'll probably find that you need to play around with the settings to make your graphics work out the way you'd like:
    The picture Chart in Excel 365

See also this tip in French: Comment créer un graphique d'image.

If you have any questions or suggestions, please feel free to ask OfficeToolTips team.