Starting today, Gemini can produce fully editable charts that regenerate if the spreadsheet data changes.
To create a chart, click Gemini in Sheets and type in a prompt, such as “create a chart with date on the x-axis and total on the y-axis.” Gemini will produce a chart in the side panel of Sheets, and once you insert it, the chart will appear on a new tab. There, you’ll be able to edit all aspects of the chart, including title, colors, and more.
Who’s impacted
End users
Why you’d use it
This functionality enables users to generate editable charts using Gemini in Sheets. For example:
- A marketing manager analyzing campaign performance can ask “Create a bar chart showing campaign performance by market.”
- A small business owner managing cash flow can ask “Create a line graph with my annual projects each month this year.”
- A financial analyst investigating inventory trends can ask “create a pie chart showing the inventory amount breakdown from the past year.”
Additional details
- Generated charts are tied to the data in the newly created tab, not to the originally analyzed data. Any changes you want to make to the data in the chart should be made in the new tab.
- For the most accurate results, ensure your data is in a consistent format, with clear headers and no missing values.
- When asking Gemini in Sheets to analyze your data, be as specific as possible in your prompts to ensure Gemini understands your request.
- For complex analysis, Gemini in Sheets’ performance is most consistent in files below 1 million cells.
- For certain chart types, Gemini in Sheets may still produce charts as images. Image charts are not directly editable or linked to your Sheet data, so they won’t update automatically if your data changes.
Getting started
- Admins: To access Gemini in the side panel of Workspace apps, users need to have smart features and personalization turned on. Admins can turn on default personalization setting for their users in the Admin console.
- End users: You can access Gemini for Sheets in the side panel by clicking on “Ask Gemini” (spark button) in the top right corner of Sheets. Visit the Help Center to learn more about collaborating with Gemini in Sheets.
Rollout pace
- Rapid Release and Scheduled Release domains: Full rollout (1–3 days for feature visibility) starting on June 9, 2025
Availability
Available for Google Workspace:
- Business Standard and Plus
- Enterprise Standard and Plus
- Customers with the Gemini Education or Gemini Education Premium add-on
- Google AI Pro and Ultra
Anyone who previously purchased these add-ons will also receive this feature:
- Gemini Business*
- Gemini Enterprise*
*As of January 15, 2025, we’re no longer offering the Gemini Business and Gemini Enterprise add-ons for sale. Please refer to this announcement for more details.