I am utterly shocked it has taken this long for something like this to come around.

Agreed.

The default output of a spreadsheet these days should be an embedded web component. Live graphs, linked to data source, edit and customize.