(function () {
  var highcharts = document.createElement('script');

  var cdn = 'https://code.highcharts.com/';
  var loaded = 0;

  var scripts = [
    "stock/highstock.js",
    "highcharts-more.js",
    "highcharts-3d.js",
    "modules/data.js",
    "modules/exporting.js",
    "modules/funnel.js",
    "modules/solid-gauge.js"
  ];

  var options = {"chart":{"backgroundColor":"#ffffff","type":"column","inverted":true,"polar":false,"height":600},"yAxis":[{"title":{"text":""}}],"colors":["#93a7bb","#2e4964","#90ed7d","#f7a35c","#8085e9","#f15c80","#e4d354","#2b908f","#f45b5b","#91e8e1"],"xAxis":[{"lineColor":"#0f2943","tickLength":0,"labels":{"style":{"color":"#2e4964"}}}],"legend":{"itemStyle":{"color":"#2e4964","fontWeight":"'light'"},"title":{"style":{"fontWeight":"regular"}},"align":"center","reversed":true},"subtitle":{"style":{"color":"#748a9d"},"align":"left","text":"Anteil der Kinder in Betreuung und Anteil ohne Betreuungsplatz, obwohl sich die Eltern einen wünschen, in Prozent"},"credits":{"style":{"color":"#748a9d"},"position":{"x":10,"align":"left"},"text":"Quellen: BMFSFJ, 2016; Statistisches Bundesamt, 2017a, 2018a; eigene Berechnungen","href":""},"title":{"align":"left","style":{"color":"#2e4964","fontWeight":"bold"},"text":"Betreuungssituation in den Bundesländern"},"plotOptions":{"bar":{"dataLabels":{"color":"#2e4964"},"borderWidth":0},"series":{"dataLabels":{"enabled":true,"style":{"color":"#2e4964","fontSize":"11px","fontWeight":"bold","textOutline":""}},"animation":false,"stacking":"normal"},"column":{"dataLabels":{"align":"center","allowOverlap":true,"borderRadius":0,"borderWidth":0,"format":"{point.y:,.1f}","inside":true,"shadow":false},"shadow":false,"borderWidth":1}},"series":[{"data":[["Sachsen-Anhalt",5.7],["Mecklenburg-Vorpommern",3.1],["Brandenburg",7.5],["Thüringen",5.9],["Sachsen",5.7],["Hamburg",5.5],["Berlin",13.4],["Schleswig-Holstein",13.5],["Rheinland-Pfalz",15],["Hessen",13.2],["Niedersachsen",13.8],["Baden-Württemberg",12.8],["Saarland",12.1],["Bayern",14.7],["Bremen",20.8],["Nordrhein-Westfalen",15.6]],"name":"Betreuungslücke","turboThreshold":0,"index":0},{"data":[["Sachsen-Anhalt",57],["Mecklenburg-Vorpommern",56],["Brandenburg",55.8],["Thüringen",53.2],["Sachsen",50.5],["Hamburg",44.7],["Berlin",44.4],["Schleswig-Holstein",32],["Rheinland-Pfalz",30.9],["Hessen",30.2],["Niedersachsen",29.8],["Baden-Württemberg",28.7],["Saarland",28.3],["Bayern",27.4],["Bremen",26.4],["Nordrhein-Westfalen",26.3]],"name":"Kinder in Betreuung","turboThreshold":0,"index":1,"dataLabels":{"style":{"color":"#ffffff"}}}],"meta":{"js":{"lib":{"version":"1.0.012"}},"highcharts":{"version":"4.1.8"}},"data":{"csv":"\"Bundesland\";\"Betreuungslücke\";\"Kinder in Betreuung\"\n\"Sachsen-Anhalt\";\"5,7\";\"57,0\"\n\"Mecklenburg-Vorpommern\";\"3,1\";\"56,0\"\n\"Brandenburg\";\"7,5\";\"55,8\"\n\"Thüringen\";\"5,9\";\"53,2\"\n\"Sachsen\";\"5,7\";\"50,5\"\n\"Hamburg\";\"5,5\";\"44,7\"\n\"Berlin\";\"13,4\";\"44,4\"\n\"Schleswig-Holstein\";\"13,5\";\"32,0\"\n\"Rheinland-Pfalz\";\"15,0\";\"30,9\"\n\"Hessen\";\"13,2\";\"30,2\"\n\"Niedersachsen\";\"13,8\";\"29,8\"\n\"Baden-Württemberg\";\"12,8\";\"28,7\"\n\"Saarland\";\"12,1\";\"28,3\"\n\"Bayern\";\"14,7\";\"27,4\"\n\"Bremen\";\"20,8\";\"26,4\"\n\"Nordrhein-Westfalen\";\"15,6\";\"26,3\""},"exporting":{"sourceWidth":600,"sourceHeight":400,"scale":"5","filename":"Betreuungssituation"},"pane":{"background":[]},"responsive":{"rules":[]},"tooltip":{"headerFormat":"<span style=\"font-size: 10px\">{point.key}</span><br/>","pointFormat":"{series.name}: <b>{point.y:,.1f} Prozent</b><br/>"},"lang":{"decimalPoint":",","thousandsSep":"."}};

  function isScriptAlreadyIncluded(src){
    var scripts = document.getElementsByTagName("script");
    for (var i = 0; i < scripts.length; i++) {
      if (scripts[i].hasAttribute('src')) {
        if ((scripts[i].getAttribute('src') || '').indexOf(src) >= 0) {
          return true;
        }
      }
    }
    return false;
  }

  function createChart() {
    if (typeof window['Highcharts'] !== 'undefined') {

    // if (!window.HighchartsCloud.hasWrapped) {
// Handle spreadsheet loading
try {
Highcharts.wrap(Highcharts.Data.prototype,"parseGoogleSpreadsheet",function(e){function t(e){function t(e){return'"'+e+'"'}var a,r=[],s=e.feed.entry,l=(s.length,0);s.forEach(function(e){var n=e.gs$cell||!1,o=!!n&&parseInt(n.row,10)-1,a=!!n&&parseInt(n.col,10)-1,s=null;n&&(n.numericValue?s=n.$t.indexOf("/")>=0||n.$t.indexOf("-")>=0?n.$t:n.$t.indexOf("%")>=0?100*parseFloat(n.numericValue):parseFloat(n.numericValue):n.$t&&(s=t(n.$t)),r[o]=r[o]||[],r[o][a]=s,a>l&&(l=a+1))}),a=r.map(function(e){for(var t=[],n=e.length;n<l;n++)t.push(null);return e.concat(t).join(";")}).join("\n"),n.parseCSV({startRow:o.startRow,endRow:o.endRow,startColumn:o.startColumn,endColumn:o.endColumn,csv:a,itemDelimiter:";"})}var n=this,o=this.options,a=o.googleSpreadsheetKey,r=o.googleSpreadsheetWorksheet,s=new XMLHttpRequest;a&&("undefined"===r&&(r="od6"),s.open("GET","https://spreadsheets.google.com/feeds/cells/"+a+"/"+(r||"od6")+"/public/values?alt=json",!0),s.setRequestHeader("Content-Type","application/json"),s.onreadystatechange=function(){if(4===s.readyState&&200===s.status){var e;try{e=JSON.parse(s.responseText)}catch(e){return!1}t(e)}},s.send(!0))});
} catch (e) {}
     // HighchartsCloud.hasWrapped = true;
   // }

 
    if (options.yAxis && options.yAxis.length === 1) options.yAxis = options.yAxis[0];
    if (options.xAxis && options.xAxis.length === 1) options.xAxis = options.xAxis[0];
    if (options.zAxis && options.zAxis.length === 1) options.zAxis = options.zAxis[0];

    /*
// Sample of extending options:
Highcharts.merge(true, options, {
    chart: {
        backgroundColor: "#bada55"
    },
    plotOptions: {
        series: {
            cursor: "pointer",
            events: {
                click: function(event) {
                    alert(this.name + " clicked\n" +
                          "Alt: " + event.altKey + "\n" +
                          "Control: " + event.ctrlKey + "\n" +
                          "Shift: " + event.shiftKey + "\n");
                }
            }
        }
    }
});
*/

function addCalloutBubbles() {
  //*
  var size = 20,
  	href = 'https://www.iwkoeln.de';
  this.renderer.image(
        'https://www.iwkoeln.de/assets/build/images/logo-iw.svg',
        this.plotWidth + this.plotLeft - 32, 
        this.chartHeight -  28,
        33,
        22
      )
      .on('click', function() {
          window.location.href = href;
      })
      .css({
          cursor: 'pointer',
          color: '#999999',
          fontSize: '9px'
      })
      .add();
  
  // */
}


Highcharts.merge(true, options, {
  chart: {
    events: {
      load: addCalloutBubbles
    },
    style: {             
      fontFamily: "'Source Sans Pro',Tahoma,Verdana,sans-serif"
    },
    spacingBottom: 20
  }
});






      if (options && (options.lang || options.global)) {
        Highcharts.setOptions({
          global: options.global || {},
          lang: options.lang || {}
        });
      }

      new Highcharts.Chart('highcharts-SJbqTEdIf', options);
    }
  }

  function check() {
    if (loaded === scripts.length) {
      for (var i = 0; i < window.HighchartsCloud.ondone.length; i++) {
        try {
          window.HighchartsCloud.ondone[i]();
        } catch(e) {
          console.error(e);
        }
      }
    }
    window.HighchartsCloud.hasLoaded = true;
  }

  function loadScript(s) {
  
    function next() {
      ++loaded;
      if (loaded < scripts.length) {
        loadScript(scripts[loaded]);
      }
      check();
    }

    if (isScriptAlreadyIncluded(s)) {
      return next();
    }

    var n = document.createElement('script');

    n.onload = function () {
      next();
    };

    if (s.indexOf('https') >= 0) {
      n.src = s;
    } else {
      n.src = cdn + s;
    }
    document.body.appendChild(n);
  }

  if (typeof window['HighchartsCloud'] === 'undefined') {
    window.HighchartsCloud = {
      ondone: [createChart],
      hasWrapped: false,
      hasLoaded: false
    };

    loadScript(scripts[0]);

  } else {
    if (window.HighchartsCloud.hasLoaded) {
      createChart();
    } else {
      window.HighchartsCloud.ondone.push(createChart);
    }
  }

  try {
    var r = new XMLHttpRequest();
    r.open('POST', 'https://api.everviz.com:443/chart/149053/10/view', true);
    r.setRequestHeader('Content-Type', 'application/json');
    r.send();
  } catch (e) {
  }

}());