Creating picture charts

Excel 365 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 2016

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

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

   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 2016
  • Excel displays the Chart Tools, adding the Design and Format tabs.

    Under Chart Tools, on the Format tab, in the Current Selection group, click the Format Selection icon:

    Format Selection in Excel 2016

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

  • Choose the Picture or texture fill option,
  • In the Insert picture from group, choose a way to insert a picture,
  • 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 2016

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.