I really despise Microsoft (from an irrational place) and even I have to agree that Sheets is relatively crippled.

Even basic chart types are not supported, I think it might be due to limits of what's possible in the browser.

Granted though, excel can't backed on bigquery.