In February 2016 I posted a spreadsheet with examples of linking to the Python Matplotlib library with xlwings. Since then updates to xlwings required some changes to the python code, specifically plot.show has been replaced with pictures.add.
The spreadsheet has now been updated, and can be downloaded from:
xlMatPlot.zip
Similar code has also been updated in the xlwScipy spreadsheet:
xlScipy-xlw.zip
A typical graph example is shown in the scree shot below:
See linking to the Python Matplotlib library for more details. The code in the post has now also been updated.