
Paul Gudgeon
Google Sheets Javascript
Sample Google Workbook
with script and Charts from data
If you want to see the full working copy of the embedded Google Sheet, click on this link. You should also be able to change report periods or years and get the charts to update. For those interested in the underlying code, the scripts are viewable through the script editor on the tools menu.
(It may have been disabled due to library updates, the script is available through a link button).