'Test the creation of a simple XlsxWriter file.'

def test_create_file(self):

    workbook = Workbook(self.got_filename)
    worksheet = workbook.add_worksheet()
    chart = workbook.add_chart({'type': 'column'})
    chart.axis_ids = [56159232, 61364096]
    data = [[10000000, 20000000, 30000000, 20000000, 10000000]]
    worksheet.write_column(0, 0, data[0])
    chart.add_series({'values': '=Sheet1!$A$1:$A$5'})
    chart.set_y_axis({'display_units': 'trillions', 'display_units_visible': 0})
    worksheet.insert_chart('E9', chart)
    workbook.close()
    self.assertExcelEqual()
