How to create a bar chart in Excel with Python and OpenPyXL Step 1 Import the necessary libraries Step 2 Add data to the spreadsheet Step 3 Create the bar chart The bar_chart.xlsx Excel file is created and saved in the same directory with the kernel Below is a screenshot of the Excel file that is automated