Put list data into a Excel file.

OpenPyXL

Create excel charts with xlsxwriter

Read the excel data using xlrd module

Format Excel files with xlsxwriter