python - xlsxwriter merge cell and chart formats - Stack Overflow

Question

1. How to merge cells in the same row and center the text

2. How to set the background color of the line chart

Answer 1

yellow=wbk.add_format({'border':1,'align':'center','bg_color':'C0504D','font_size':12,'font_color':'white'})
sheet.merge_range(0,0,0,10,data,yellow)