Creating charts in Excel

Spreadsheets include a lot of tools to deal with data, including presenting the data in colorful charts. Let's see how to append a chart programmatically to an Excel spreadsheet.

Getting ready

We will use the module openpyxl. We should install the module, adding it to our requirements.txt file as follows:

$ echo "openpyxl==2.5.4" >> requirements.txt
$ pip install -r requirements.txt

We'll store in the new file information about the movies with the most attendance. Data is extracted from here:

http://www.mrob.com/pub/film-video/topadj.html.

How to do it...

...