Gemini AI Revolutionizes Chart Creation in Google Sheets with Dynamic, Editable Visualizations

Gemini is now a chart building mastermind with the latest Google Sheets update

Summary Gemini AI can now create live and editable charts in Google Sheets. Prompt Gemini to use specific data for a y-axis and x-axis and it will insert a chart in a Sheets tab. This is rolling out to Google Workspace users starting June 9. Google Sheets is taking a big leap forward, thanks to a powerful upgrade with help from Gemini. Google's AI assistant can now generate fully editable charts that update automatically as your spreadsheet data changes. Related 9 unique ways to use Google Sheets beyond number crunching Think outside the cell Posts 4 Gemini's earlier chart generation tools were limited to images that didn't respond to data edits. Now, users can prompt Gemini to create dynamic charts, no more static images required. Editable and live charts build by AI Source: Google Google has kept this new feature simple to use. Click the Gemini icon in the Google Sheets die panel and type a prompt. Be sure to let it know what data to use for the y-axis and x-axis. Gemini will then generate a preview in the side panel. Inserting it places a chart directly into a new tab in your spreadsheet. Create a chart with date on the x-axis and total on the y-axis This chart is fully editable. You can change the title, color scheme, and even the date range. The chart itself will update automatically if and when the data on the chart tab changes, making it a useful dynamic tool for analysis. It's worth noting that the generated chart is tied to the newly-created tab, not the original spreadsheet data. Updating data in the original tab will not affect the chart. There are some limitations Not every chart type will be editable. Some more complex visualizations may still be generated as static images. Sheets with over 1 million cells, or those with inconsistent data formatting, will likely not work at all. Still, this is a major upgrade for Sheets. Users no longer need to wrestle with the chart editor. A good prompt and a clean dataset is all Gemini needs to do the heavy lifting. The new feature is available now for Google Workspace users, including Business Standard, Plus, and Enterprise users. Anyone with the old Gemini add-on can also use it. It began rolling out on June 9 and will reach all eligible users over the next few days. Make sure your version of Sheets is up to date and Gemini is enabled in your Workspace settings.

Stop the presses - Gemini and Google Sheets may have finally solved one of the most annoying spreadsheet quirks

Creating the spreadsheet of your dreams may be a step closer thanks to a new Gemini boost for Google Sheets. The AI platform is now able to create fully editable charts based on your Google Sheets data, giving users greater insights than ever before. Previously, users could only generate charts which could be included as static images, able to be moved or pasted over existing cells, but Gemini has now taken this to a whole new level. Users can now fire up Gemini in Google Sheets using the usual side panel launch, and enter a prompt such as "create a chart with date on the x-axis and total on the y-axis." Gemini will use this to create a chart in the side panel of Sheets, which can then be inserted, first on a new tab, where various attributes can be edited, such as title, colors, and more. What's more, as you change your data in the spreadsheet, your chart will also change to reflect this, rather than having to create a new chart each time. In a Google Workspace updates blog post announcing the news, the company notes the new tool offers far more flexibility than previous situations, where charts were flat and uneditable. It offered a range of possible use cases, from a marketing manager analyzing campaign performance across different sectors to a small business owner managing cash flow across different projects each month this year. The feature is rolling out now, and will be available across multiple Google Workspace tiers. This includes Business Standard and Plus, Enterprise Standard and Plus, customers with the Gemini Education or Gemini Education Premium add-on, and Google AI Pro and Ultra users. Users who have previously purchased the Gemini Business or Gemini Enterprise add-ons will also receive the feature.