1 2 Previous Next 21 Replies Latest reply on Aug 14, 2018 6:27 AM by Michael Gillespie

    Help combining shape file with points on map - based on region common field

    naresh.suglani.0

      Hi all , can anyone help with the problem I'm having creating this map?

       

      I have a shape file and excel file both having common fields containing some UK regions. The shape file has this in the column named merged and the excel file contains them in the column named region.

       

      I want to overlap the point date on top of the shape file so that when I use a filter to select a particular region, for example Midlands, the map zooms in to that region and also shows the points contained within that region.

       

      So far all my attempts (even using the very good guide from Sarah Battersby) have failed. I can create a dual axis map no problem but when I zoom into a region the points don't show.

       

      I've attached the files here is anyone can assist.

       

      Thanks in advance.

        1 2 Previous Next