Help with choropleth mapping...

Discussion created by charlotterobin on Nov 19, 2010
Latest reply on Nov 19, 2010 by Dan_Patterson
...I am new to this so please bear with me! I am trying to make a map of how many passports are checked per county in the UK. I have a table with my grid references (eastings/northings) county and number of checks, which I have added as x,y data onto my map of the UK. I know I need to join my table and basemap to make a choropleth map, however I seem to be having a few problems when I do this. Some of the counties that have definitely checked passports are showing up as "0". When I use the identify tool and click on the point for that data, it appears that somehow the data has got mixed up i.e. Lancashire has checked 500 passports but when I click on the point that is in Lancashire it actually thinks it is London and has no passports!

Is this something to do with the projection? I have double checked and the projection is the British National Grid so not really sure what is going wrong? If anyone could offer some advice that would be great!

Ps I have done plenty of other maps without this problem, for some reason it just doesn't like this dataset!

Thanks :)