Gemini can use Python to build data visualization graphics in Sheets; You can also interact with it by asking questions about your data; However charts won’t auto-update from live data sets ...

Additionally, Gemini can be asked to generate charts based on data in a Sheet: Charts are generated as static images and can be easily inserted into your sheet.