python - xlsxwriter chart with multiple categories -


my excel chart has 2 index columns: 'month' , 'year'. how can combine them in python code below achieve graph looks 1 below? specific, how specify multiple categories?

chart.add_series({     'categories': .............,     'values': ['sheet 1', 0, 1, 10, 1] }) 

excel graph want achieve

i tried:

chart.add_series({     'categories': [['sheet1', 0, 0, 10, 0], ['sheet1', 0, 1, 10, 1]]     'values': ['sheet1', 0, 2, 10, 2] }) 

xlsxwriter supports clustered charts this. see example docs.

enter image description here

the main trick work specify categories 2d ranges (from column column b). creates clusters.


Comments

Popular posts from this blog

php - Vagrant up error - Uncaught Reflection Exception: Class DOMDocument does not exist -

vue.js - Create hooks for automated testing -

Add new key value to json node in java -