Generating maps from a table

Statistics.gov.scot provides views of Geography in context from both the Atlas and Data tabs. In the Atlas section you can view geographies in relation to the areas they sit within and you can also see the areas and organisations which form part of that area you’re looking at. See the Understanding Atlas and find data by browsing area guides for more on this.

This guide shows how to generate maps and chart from a table. 

In the Data section you can view data across areas by filtering to a table within a dataset and then looking at a single column in that spreadsheet more closely.

  • From a table view of the data, go to the top of a column to get to a drop down menu.
  • Select ‘Visualise this column’
  • You will get a view of the areas from the spreadsheet (in the below example, council areas) and the data from the spreadsheet for them. In this example, hovering over the map shows Estimated Percentage of Working Age Households on Low Income (less than 60% median) Before Housing Costs (Bhc).

The legend at the side shows the ratio brackets on the map. By hovering over different areas you can view this in context.

  • Change your view of the geography type shown by going to the drop down menu beneath the map.
  • If the data is available, this is where you can change the view from council areas to datazones for a more granular view of areas. If the data isn’t there this option won’t be either.

Summary

To generate a map
  • Within a dataset, navigate to a table view of the data
  • Decide which column in the table that you want to view data across areas for
  • Go to the top of that column and click on the down arrow to view a dropdown menu
  • Select ‘Visualise this column’
  • You will be taken to a map, with a legend at the side, which shows the data over areas. Hover over different areas to see their name (and if appropriate, code and value)
  • Edit your view by choosing a different area category from the drop down list beneath the map

To continue exploring our data, go to statistics.gov.scot

Still need help? Contact Us Contact Us