google.load("visualization", "1", {packages: ["linechart", "barchart", "columnchart"]});

var fig2_1;

var fig2_2;

var fig2_3;

var fig2_4;

var fig2_6;



function drawVisualization() {

    var fig2_1 = new (google.visualization.DataTable);

    fig2_1.addColumn("string", "Year");

    fig2_1.addColumn("number", "England");

    fig2_1.addColumn("number", "Wales");

    fig2_1.addColumn("number", "Scotland");

    fig2_1.addColumn("number", "Northern Ireland");

    fig2_1.addRows(4);

    fig2_1.setCell(0, 0, "1981");

    fig2_1.setCell(0, 1, 46.821);

    fig2_1.setCell(0, 2, 2.814);

    fig2_1.setCell(0, 3, 5.18);

    fig2_1.setCell(0, 4, 1.543);

    fig2_1.setCell(1, 0, "1991");

    fig2_1.setCell(1, 1, 47.875);

    fig2_1.setCell(1, 2, 2.873);

    fig2_1.setCell(1, 3, 5.083);

    fig2_1.setCell(1, 4, 1.607);

    fig2_1.setCell(2, 0, "2001");

    fig2_1.setCell(2, 1, 49.45);

    fig2_1.setCell(2, 2, 2.91);

    fig2_1.setCell(2, 3, 5.064);

    fig2_1.setCell(2, 4, 1.689);

    fig2_1.setCell(3, 0, "2007");

    fig2_1.setCell(3, 1, 50.763);

    fig2_1.setCell(3, 2, 2.966);

    fig2_1.setCell(3, 3, 5.117);

    fig2_1.setCell(3, 4, 1.742);

    var fig2_2 = new (google.visualization.DataTable);

    fig2_2.addColumn("string", "Year");

    fig2_2.addColumn("number", "England - in");

    fig2_2.addColumn("number", "England - out");

    fig2_2.addColumn("number", "Wales - in");

    fig2_2.addColumn("number", "Wales - out");

    fig2_2.addColumn("number", "Scotland - in");

    fig2_2.addColumn("number", "Scotland - out");

    fig2_2.addColumn("number", "Northern Ireland - in");

    fig2_2.addColumn("number", "Northern Ireland - out");

    fig2_2.addRows(6);

    fig2_2.setCell(0, 0, "1991");

    fig2_2.setCell(0, 1, 96);

    fig2_2.setCell(0, 2, -112);

    fig2_2.setCell(0, 3, 51);

    fig2_2.setCell(0, 4, -47);

    fig2_2.setCell(0, 5, 56);

    fig2_2.setCell(0, 6, -47);

    fig2_2.setCell(0, 7, 14);

    fig2_2.setCell(0, 8, -11);

    fig2_2.setCell(1, 0, "1996");

    fig2_2.setCell(1, 1, 111);

    fig2_2.setCell(1, 2, -105);

    fig2_2.setCell(1, 3, 55);

    fig2_2.setCell(1, 4, -53);

    fig2_2.setCell(1, 5, 47);

    fig2_2.setCell(1, 6, -54);

    fig2_2.setCell(1, 7, 12);

    fig2_2.setCell(1, 8, -14);

    fig2_2.setCell(2, 0, "2001");

    fig2_2.setCell(2, 1, 104);

    fig2_2.setCell(2, 2, -120);

    fig2_2.setCell(2, 3, 60);

    fig2_2.setCell(2, 4, -51);

    fig2_2.setCell(2, 5, 56);

    fig2_2.setCell(2, 6, -50);

    fig2_2.setCell(2, 7, 13);

    fig2_2.setCell(2, 8, -12);

    fig2_2.setCell(3, 0, "2005");

    fig2_2.setCell(3, 1, 98);

    fig2_2.setCell(3, 2, -118);

    fig2_2.setCell(3, 3, 56);

    fig2_2.setCell(3, 4, -50);

    fig2_2.setCell(3, 5, 59);

    fig2_2.setCell(3, 6, -45);

    fig2_2.setCell(3, 7, 12);

    fig2_2.setCell(3, 8, -12);

    fig2_2.setCell(4, 0, "2006");

    fig2_2.setCell(4, 1, 96);

    fig2_2.setCell(4, 2, -110);

    fig2_2.setCell(4, 3, 56);

    fig2_2.setCell(4, 4, -49);

    fig2_2.setCell(4, 5, 50);

    fig2_2.setCell(4, 6, -44);

    fig2_2.setCell(4, 7, 12);

    fig2_2.setCell(4, 8, -12);
	
	fig2_2.setCell(5, 0, "2007");

    fig2_2.setCell(5, 1, 92);

    fig2_2.setCell(5, 2, -114);

    fig2_2.setCell(5, 3, 55);

    fig2_2.setCell(5, 4, -48);

    fig2_2.setCell(5, 5, 56);

    fig2_2.setCell(5, 6, -41);

    fig2_2.setCell(5, 7, 12);

    fig2_2.setCell(5, 8, -11);

    var fig2_3 = new (google.visualization.DataTable);

    fig2_3.addColumn("string", "Year");

    fig2_3.addColumn("number", "England - in");

    fig2_3.addColumn("number", "England - out");

    fig2_3.addColumn("number", "Wales - in");

    fig2_3.addColumn("number", "Wales - out");

    fig2_3.addColumn("number", "Scotland - in");

    fig2_3.addColumn("number", "Scotland - out");

    fig2_3.addRows(6);

    fig2_3.setCell(0, 0, "1991");

    fig2_3.setCell(0, 1, 294);

    fig2_3.setCell(0, 2, -245);

    fig2_3.setCell(0, 3, 10);

    fig2_3.setCell(0, 4, -8);

    fig2_3.setCell(0, 5, 21);

    fig2_3.setCell(0, 6, -27);

    fig2_3.setCell(1, 0, "1996");

    fig2_3.setCell(1, 1, 291);

    fig2_3.setCell(1, 2, -230);

    fig2_3.setCell(1, 3, 8);

    fig2_3.setCell(1, 4, -8);

    fig2_3.setCell(1, 5, 16);

    fig2_3.setCell(1, 6, -22);

    fig2_3.setCell(2, 0, "2001");

    fig2_3.setCell(2, 1, 438);

    fig2_3.setCell(2, 2, -270);

    fig2_3.setCell(2, 3, 10);

    fig2_3.setCell(2, 4, -9);

    fig2_3.setCell(2, 5, 27);

    fig2_3.setCell(2, 6, -23);

    fig2_3.setCell(3, 0, "2005");

    fig2_3.setCell(3, 1, 509);

    fig2_3.setCell(3, 2, -316);

    fig2_3.setCell(3, 3, 11);

    fig2_3.setCell(3, 4, -10);

    fig2_3.setCell(3, 5, 37);

    fig2_3.setCell(3, 6, -30);

    fig2_3.setCell(4, 0, "2006");

    fig2_3.setCell(4, 1, 530);

    fig2_3.setCell(4, 2, -361);

    fig2_3.setCell(4, 3, 15);

    fig2_3.setCell(4, 4, -10);

    fig2_3.setCell(4, 5, 38);

    fig2_3.setCell(4, 6, -26);

    fig2_3.setCell(5, 0, "2007");

    fig2_3.setCell(5, 1, 511);

    fig2_3.setCell(5, 2, -299);

    fig2_3.setCell(5, 3, 16);

    fig2_3.setCell(5, 4, -7);

    fig2_3.setCell(5, 5, 41);

    fig2_3.setCell(5, 6, -28);

	

    var fig2_4 = new (google.visualization.DataTable);

    fig2_4.addColumn("string", "Year");

    fig2_4.addColumn("number", "Net migration & other changes");

    fig2_4.addColumn("number", "Total changes");

    fig2_4.addRows(5);

    fig2_4.setCell(0, 0, "UK");

    fig2_4.setCell(0, 1, 201.1);

    fig2_4.setCell(0, 2, 388);

    fig2_4.setCell(1, 0, "England");

    fig2_4.setCell(1, 1, 154.7);

    fig2_4.setCell(1, 2, 329.1);

    fig2_4.setCell(2, 0, "Wales");

    fig2_4.setCell(2, 1, 11.8);

    fig2_4.setCell(2, 2, 14.1);

    fig2_4.setCell(3, 0, "Scotland");

    fig2_4.setCell(3, 1, 26.2);

    fig2_4.setCell(3, 2, 27.3);

    fig2_4.setCell(4, 0, "Northern Ireland");

    fig2_4.setCell(4, 1, 8.4);

    fig2_4.setCell(4, 2, 17.5);

	

	var fig2_6 = new (google.visualization.DataTable);

	fig2_6.addColumn("string", "Year");

    fig2_6.addColumn("number", "England");

    fig2_6.addColumn("number", "Wales");

	fig2_6.addColumn("number", "Scotland");

	fig2_6.addColumn("number", "Northern Ireland");

    fig2_6.addRows(13);

	fig2_6.setCell(0,0,"1981");

	fig2_6.setCell(0,1,17.36);

	fig2_6.setCell(0,2,1.03);

	fig2_6.setCell(0,3,1.88);

	fig2_6.setCell(0,4,null);

	fig2_6.setCell(1,0,"1991");

	fig2_6.setCell(1,1,19.17);

	fig2_6.setCell(1,2,1.14);

	fig2_6.setCell(1,3,2.04);

	fig2_6.setCell(1,4,null);

	fig2_6.setCell(2,0,"2001");

	fig2_6.setCell(2,1,20.52);

	fig2_6.setCell(2,2,1.21);

	fig2_6.setCell(2,3,2.20);

	fig2_6.setCell(2,4,null);

	fig2_6.setCell(3,0,"2002");

	fig2_6.setCell(3,1,20.72);

	fig2_6.setCell(3,2,1.22);

	fig2_6.setCell(3,3,2.21);

	fig2_6.setCell(3,4,null);

	fig2_6.setCell(4,0,"2003");

	fig2_6.setCell(4,1,20.90);

	fig2_6.setCell(4,2,1.24);

	fig2_6.setCell(4,3,2.23);

	fig2_6.setCell(4,4,null);

	fig2_6.setCell(5,0,"2004");

	fig2_6.setCell(5,1,21.06);

	fig2_6.setCell(5,2,1.25);

	fig2_6.setCell(5,3,2.25);

	fig2_6.setCell(5,4,null);

	fig2_6.setCell(6,0,"2005");

	fig2_6.setCell(6,1,21.30);

	fig2_6.setCell(6,2,1.26);

	fig2_6.setCell(6,3,2.27);

	fig2_6.setCell(6,4,null);

	fig2_6.setCell(7,0,"2006");

	fig2_6.setCell(7,1,21.52);

	fig2_6.setCell(7,2,1.27);

	fig2_6.setCell(7,3,2.29);

	fig2_6.setCell(7,4,0.672);

	fig2_6.setCell(8,0,"2011");

	fig2_6.setCell(8,1,22.75);

	fig2_6.setCell(8,2,1.34);

	fig2_6.setCell(8,3,2.40);

	fig2_6.setCell(8,4,0.721);

	fig2_6.setCell(9,0,"2016");

	fig2_6.setCell(9,1,24.11);

	fig2_6.setCell(9,2,1.42);

	fig2_6.setCell(9,3,2.50);

	fig2_6.setCell(9,4,null);

	fig2_6.setCell(10,0,"2021");

	fig2_6.setCell(10,1,25.44);

	fig2_6.setCell(10,2,1.48);

	fig2_6.setCell(10,3,2.59);

	fig2_6.setCell(10,4,0.798);

	fig2_6.setCell(11,0,"2026");

	fig2_6.setCell(11,1,26.67);

	fig2_6.setCell(11,2,1.54);

	fig2_6.setCell(11,3,2.67);

	fig2_6.setCell(11,4,null);

	fig2_6.setCell(12,0,"2031");

	fig2_6.setCell(12,1,27.82);

	fig2_6.setCell(12,2,1.59);

	fig2_6.setCell(12,3,2.73);

	fig2_6.setCell(12,4,0.863);

	

	(new (google.visualization.LineChart)(document.getElementById("figure2_1"))).draw(fig2_1, {width: 706, height: 300, legend: "bottom", titleY: "Millions"});

    drawToolbar2_1();



    function drawToolbar2_1() {

        var components = [{type: "csv", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_1"}, {type: "igoogle", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_1", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}}, {type: "html", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_1"}, {type: "htmlcode", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_1", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}, style: "width: 800px; height: 700px; border: 3px solid purple;"}];

        var container = document.getElementById("toolbar_2_1");

        google.visualization.drawToolbar(container, components);

    }



    (new (google.visualization.ColumnChart)(document.getElementById("figure2_2"))).draw(fig2_2, {width: 706, height: 300, legend: "bottom", titleY: "Inter-Regional Migration - Thousands"});

    drawToolbar2_2();



    function drawToolbar2_2() {

        var components = [{type: "csv", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_2"}, {type: "igoogle", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_2", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}}, {type: "html", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_2"}, {type: "htmlcode", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_2", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}, style: "width: 800px; height: 700px; border: 3px solid purple;"}];

        var container = document.getElementById("toolbar_2_2");

        google.visualization.drawToolbar(container, components);

    }



    (new (google.visualization.ColumnChart)(document.getElementById("figure2_3"))).draw(fig2_3, {width: 706, height: 300, legend: "bottom", titleY: "Thousands"});

    drawToolbar2_3();



    function drawToolbar2_3() {

        var components = [{type: "csv", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_3"}, {type: "igoogle", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_3", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}}, {type: "html", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_3"}, {type: "htmlcode", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_3", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}, style: "width: 800px; height: 700px; border: 3px solid purple;"}];

        var container = document.getElementById("toolbar_2_3");

        google.visualization.drawToolbar(container, components);

    }



    (new (google.visualization.ColumnChart)(document.getElementById("figure2_4"))).draw(fig2_4, {width: 706, height: 300, legend: "bottom", titleY: "Thousands"});

    drawToolbar2_4();



    function drawToolbar2_4() {

        var components = [{type: "csv", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_4"}, {type: "igoogle", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_4", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}}, {type: "html", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_4"}, {type: "htmlcode", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_4", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}, style: "width: 800px; height: 700px; border: 3px solid purple;"}];

        var container = document.getElementById("toolbar_2_4");

        google.visualization.drawToolbar(container, components);

    }



    (new (google.visualization.LineChart)(document.getElementById("figure2_6"))).draw(fig2_6, {width: 706, height: 300, legend: "bottom", titleY: "Millions"});
    drawToolbar2_6();

    function drawToolbar2_6() {

        var components = [{type: "csv", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_6"}, {type: "igoogle", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_6", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}}, {type: "html", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_6"}, {type: "htmlcode", datasource: "http://spreadsheets.google.com/ccc?key=0AkMjzin45BHwdHVnQkVtbkFkSmdjcENHN3dqRnk2Mnc&sheet=Fig2_6", gadget: "http://www.google.com/ig/modules/pie-chart.xml", userprefs: {'3d': 1}, style: "width: 800px; height: 700px; border: 3px solid purple;"}];

        var container = document.getElementById("toolbar_2_6");

        google.visualization.drawToolbar(container, components);

    }



}



google.setOnLoadCallback(drawVisualization);