Author: Oscar Cronquist Article last updated on February 05, 2018

This picture below shows you a column chart with pictures (flags) below each column.

Add pictures to a chart axis

Watch this video to learn how to build above chart or follow the instructions below.


  1. Select a data range
    Select a cell range
  2. Click "Insert" tab on the ribbon and click "Column" and then "Clustered column"
    Insert a clustered column
  3. Right click on the second series and click on "Change Series Chart Type...". Change it to x y (scatter) and click "Scatter with only markers".
    Select the second series
  4. Remove axis and legend
    Remove axis and legend
  5. Right click on x axis and click on "Format Axis..."
    Format axis
  6. Change label distance to 500
    Change label distance
  7. Click a x y scatter data point
    Click a xy scatter data point
  8. Paste a picture. I resized the picture to 25 px width first.
    Paste picture to chart
  9. Repeat step 7 and 8 with the remaining pictures.

Other uses

You can use the same technique with a bar chart.
Add pictures to a bar chart axis

Other interesting chart techniques

Download excel *.xlsx file