chart.py

  charts = [
        {
            'key': 'foresults',
            'title': 'Top Air Origins',
        },
        {
            'key': 'horesults',
            'title': 'Top Hotel Origins',
        },
        {
            'key': 'hdresults',
            'title': 'Top Hotel Destinations',
        },
        {
            'key': 'fsresults',
            'title': 'Alternate Searched Air Destinations',
        },
        {
            'key': 'fbresults',
            'title': 'Alternate Booked Air Destinations',
        },
        {
            'key': 'hsresults',
            'title': 'Alternate Searched Hotel Destinations',
        },
        {
            'key': 'hbresults',
            'title': 'Alternate Booked Hotel Destinations',
        },
    ]

	start = 53

    for definition in charts:
        chart = create_chart(results.get(definition['key']), start, definition['title'])
        worksheet.insert_chart('D%s' % start, chart)
        columns = 'A%(row)s:B%(row)s' % {'row': (start - 2)}
        worksheet.merge_range(columns, definition['title'], merge_format)
        start += 27