How to plot geo-data using matplotlib/python?

How can I create a scatter plot in Excel with custom markers using a single data series?

• I have a single data series of x values and y values that I need to plot on a scatter chart. I need to add a regression line and get the rsquare value. This is easy. Within this series there are sub-groupings that I want to distinguish. Therefore, some of the markers on the scatter plot will be squares, some triangles etc. etc. This can be done manually. I just choose the marker and set it to whatever I like in Excel 2012. The problem is that the chart legend still sees the whole scatter chart as one series and I can’t get the legend to read so that squares = England, Triangles = Scotland or whatever. At the moment the spreadsheet is basically just a column of x and a column of y values. Can I organise the spreadsheet differently so the data are still a single series but the markers automatically refer to sub-groupings within the series and the chart legend reflects this, please? Thank you.

• Answer:

  If your data is in Columns A and B with the countries in Column A and the data for that country in Column B, select the data, and insert the Scatter Plot. The points on the plot will be in the order of the countries listed in the data. Double click on one of the data points which will select all the data points, click again on the same data point and it will then be the only data point selected. Right click on the data point, click on Format Data Point, Marker Options, Built-in, select the symbol for that data point. Click Close. As soon as you do this, a legend will appear on the right with all the countries listed and will include the custom data marker that you set. Change all the markers using the above procedure and the markers in the legend will change to match the country for their data points.