Author: Oscar Cronquist Article last updated on January 31, 2019

This post describes how to add a map (background picture) to a chart. The following animated picture shows a scatter chart with a background picture. A drop down list letยดs you select a city and the chart displays the location.

Step 1 - Insert a scatter chart

1. Go to "Insert" tab on the ribbon
2. Click "Scatter" button
3. Click "Scatter with only markers" button

Step 2 - Create a drop down list

1. Select cell B14
2. Go to tab "Data" on the ribbon
3. Click "Data Validation" button
4. Go to "Settings" tab
5. Select "List"
6. Select source range: B3:B10
7. Click OK

Formula in cell C14:

=INDEX(C3:C10,MATCH(\$B\$14,\$B\$3:\$B\$10,0))

Formula in cell D14:

=INDEX(D3:D10,MATCH(\$B\$14,\$B\$3:\$B\$10,0))

Step 3 - Select chart data source

1. Right click on chart
2. Click "Select Data"
4. Select name, x value and y value.
5. Click Ok.

Step 4 - Insert a background picture

1. Right click on chart
2. Click "Format Plot Area..."
3. Click "Fill"
4. Select "Picture or texture fill"
5. Click "File..." button
6. Select a picture
7. Click "Insert"
8. If you like, change "Transparency" value
9. Click "Close"

Step 5 - Chart settings

1. Delete Legend and chart titel

2. Delete chart grid lines
3. Change x and y axis minimum and maximum value to 0 and 100
4. Make sure x and y coordinates in the table are ok
5. If you like, delete x and y axis
6. Select data series on the chart
7. Right click on data series
8. Click "Format Data Series..."
9. Click "Marker Options"
10. Select "Built-in"
11. Select a type
12. Click "Marker Fill"
13. Select "Solid fill"
14. Pick a color
15. Click Close

Final notes

First I thought of using longitude and latitude coordinates but I gave that up really quickly. The map is downloaded from Wikimedia Commons.

Tip! You can add a data label and use the series name to show the city name on the map.