pandas xlsxwriter stacked barchart

Viewed 312

I am looking to upload a grouped barchart in excel, however I can't seem to find a way to do so.

Here is my code:

bar_chart2 = workbook.add_chart({'type':'column'})
bar_chart2.add_series({
    'name':'Month over month product',
    'categories':'=Month over month!$H$2:$H$6',
    'values':'=Month over month!$I$2:$J$6',
    })
bar_chart2.set_legend({'none': True})

worksheet5.insert_chart('F8',bar_chart2)

bar_chart2.set_legend({'none': True})

worksheet5.insert_chart('F8',bar_chart2)

However, I get that. enter image description here

1 Answers
Related