Subplots using Python in Excel

preview_player
Показать описание
This second video demo how to create subplots using Python in Excel

#Excel #PythonInExcel

Python Code
df = xl("A2:J1041", headers=True)
cat_var = ['City', 'Payment_Type', 'Account_Manager']
common_fontsize = 20

for i, var in enumerate(cat_var):
axs[i].set_xticklabels(axs[i].get_xticklabels(), rotation=90)
axs[i].tick_params(axis='x', labelsize=common_fontsize)
axs[i].tick_params(axis='y', labelsize=common_fontsize)
axs[i].legend(fontsize=common_fontsize)
axs[i].set_xlabel(f'{var}', fontsize=common_fontsize + 2)
axs[i].set_ylabel('Count', fontsize=common_fontsize + 2)

Рекомендации по теме
Комментарии
Автор

That's very complicated.
Nothing Power BI can't do.
Advantages? Thank you for this tutorial.

IvanCortinas_ES
join shbcf.ru