Google Sheets expands data tools as users combine native chart updates with Claude integrations

Google is rolling out native support for box and whisker charts in Google Sheets, catching up to a longstanding feature in Microsoft Excel, according to Android Authority. Meanwhile, users paying for Anthropic's Claude can connect the chatbot directly to Sheets via an add-on and connector to generate interactive charts and dashboards without writing complex formulas, Android Police reports. [1][2]

For the native charting update, Google says Sheets will automatically calculate key statistics including the minimum, quartiles, median, maximum, mean, and outliers directly from a raw range of numeric values without helper formulas, according to Android Authority. It also preserves imported box plots from Excel with formatting and data intact. Separately, Android Police notes that Claude's Sheets add-on enables dynamic elements like dropdown filters, though external dashboards in the Claude app do not refresh automatically in real time and require reopening or clicking a refresh icon. [1][2]