OP said they "find Google Sheets charts pretty difficult and painful for quickly exploring different views of the original data"
And that they want "a bunch of common graph views I can quickly choose between"
That doesn't sound like Datasette to me, although I'd be happy to be wrong -- how would you recommend someone achieve this in Datasette?