Changelog

Follow up on the latest improvements and updates.

RSS

KPI widgets on dashboards can now work out their value from your data, so the number updates on its own when your sheet changes. When you add or edit a KPI, choose Calculated From Data in place of Custom Value, then pick a sheet, a column and a statistic.
changingKPICalculatedData
Statistics
KPIs use the same statistics as the column stats row. Number columns offer Sum, Average, Median, Minimum, Maximum and Standard Deviation. Date columns offer Earliest Date, Latest Date and the Date Range in days, months or years. Every column offers Count, Empty, Filled and Unique, plus their percentages.
Calculated KPIs also follow the slicers on the dashboard page, so the value changes as viewers filter the data.
Time periods
The Time Period tab limits the KPI to the rows whose date falls in a period. Pick a date column from the sheet, then choose a period such as Last 7 Days, Last 30 Days, Last 90 Days, Last 12 Months, This Week, This Month, This Quarter, This Year, Last Week, Last Month, Last Quarter or Last Year. Periods can end on the latest date in your data, which works well for imported files, or on today for sheets that get new rows.
Calculated trends
When a KPI has a time period, its trend can be calculated too. Under Compare To, choose Previous Period or Same Period Last Year. Averages, medians, minimums, maximums and percentages can also be compared with All Time.
The trend shows the percent change with an up or down arrow, and the trend label is written for you, though you can change it. Turn on Lower Is Better for costs, churn or wait times, so that a decrease shows in green.
Formatting
The Format tab sets how the value is written, with a number format or a custom format, significant digits, a prefix and suffix, and the number and currency locale. For example, 2,567,567 rounded to 2 significant digits shows as 2.6M.
A stats row now sits at the bottom of the data grid so you can see a summary of each column while you work with your data. Click the stat under any column to choose a different one. Your choices are saved with the chart.
Where to find it
The stats row appears on the Full Dataset and Plotted Data views of the sheet tab, and in the dashboard's Edit Sheet grid. On the Full Dataset view, the stats use your chart's filters, so the numbers match the rows you're charting. On the Plotted Data view, the stats are based on the values drawn in the chart.
Stats for number columns
Sum, Average, Median, Minimum, Maximum and Standard Deviation. Number columns show the Sum by default, and Year columns show the Count.
Stats for date columns
Earliest Date, Latest Date, and the Date Range in days, months or years.
Stats for every column
Count, Empty, Filled and Unique, plus Empty %, Filled % and Unique %. These help you find missing values or check how many different values a column holds before you chart it.
The chart toolbar above every chart now has more options, so you can change the chart type, its style, and the columns on each axis without opening the sidebar.
Chart Type and Multi-Series
The Chart Type menu lists the base chart types, each with a short description of what it shows best. Bar, Line, Scatter Plot, Area and Gauge charts have Single Series and Multi-Series options at the top of the menu.
The toolbar switches to the grouped version of a chart when you pick a Breakdown column or add a second series.
Style dropdown
A new Style dropdown sits next to the chart type and holds the settings for that type. Examples include Stacked Bars, Normalize, Horizontal Bars and Waterfall Bars for bar charts, Smooth Lines and Line Width for line charts, Semi Circle and Donut Inner Size for pie charts, and Min, Max and Target for gauges.
Easier column picking
Each axis dropdown opens a column menu with search, type filters (All, Numbers, Text and Dates), and stars on the recommended columns. Hover over a column to see its type, how many unique values it has, and a few example values. Columns where every row has the same value are shown in grey.
New: Breakdown Items
When a Breakdown has 50 items or fewer, an Items dropdown lets you choose which items appear in the chart and change the color of each one.
Read the full toolbar guide in the Quick Start.
You can now connect AI apps to InstaCharts through the InstaCharts MCP server and make charts from a chat!
Add https://api.instacharts.io/mcp as a custom connector in Claude, ChatGPT or Claude Code and sign in with your InstaCharts account. Your AI assistant can then:
  • Create a sheet from a table you paste into the chat
  • Import a CSV, Excel or JSON file from a web link, or send a large file through an upload link
  • Build any of the 15 InstaCharts chart types and render the chart to check how it looks
  • Change the chart type, columns, aggregation, sorting, colors, titles and size
  • Add, change and delete rows in a sheet
  • Share a chart with a public link and embed code
Charts your assistant makes use your workspace's theme, fonts, colors and locale. They are saved in your workspace, where you can keep editing them, add them to dashboards and export them.
When you connect, you choose whether the AI app can edit your data or only view it. You can remove its access at any time from Third Party Apps in your login settings. Each change the app makes counts as one task. Reading and listing your sheets and charts is free.
The MCP server is available on paid plans only.
You can now create a sheet from a file at a public web address and keep it updated from that link.
Import from a link
  • Choose New Sheet, then Import from a link, and paste the web address of a CSV, Excel or JSON file.
  • InstaCharts downloads the file and shows a preview with the usual import options: sheet name, header detection, column selection and file encoding.
  • Supported formats are CSV, TSV, PSV, TXT, log, JSON, JSON Lines, Excel (.xlsx, .xls, .xlsm, .xlsb), OpenDocument (.ods, .fods) and Apple Numbers.
Sync from a link
  • A sheet imported from a link keeps the link, which shows under Synced From in the sheet menu.
  • Sync Now in Sync Settings downloads the latest version of the file and replaces the sheet's data. Charts, data tables, dashboards and embeds all show the new data.
  • Paid workspaces can sync a link hourly, daily, weekly or monthly, and can pause a sync schedule at any time.
InstaCharts now has two gauge chart types for tracking goals and KPIs.
A gauge adds up or averages a column and shows the result on a dial, so readers can see at a glance how close a number is to its maximum or its target.
Learn more in the Gauge Chart and Grouped Gauge Chart docs.
Embedded charts can now carry your chart's look all the way through the embed. The toolbar and the data tables can take on your chart's background colors, so an embed on a dark website or a branded page looks like one piece.
You'll find the new settings in the Settings tab of the Share dialog.
Match Toolbar to Chart
  • Turn on Match Toolbar to Chart to color the embed toolbar with your chart's background color.
  • The toolbar text, buttons and view picker switch to light or dark colors automatically, so they stay readable on any background.
  • A chart with a transparent background keeps a transparent toolbar, so it blends into the page around it.
DataTable Colors
  • When you include the Full Dataset or Plotted Data view in your embed, use the new DataTable Colors dropdown to style the tables.
  • Choose Light for a white table with dark text, Dark for a dark table with light text, or Match Chart to follow your chart's background.
  • The same table colors apply to the full page interactive chart.
Learn more in the Embed Chart docs.
You can now invite teammates as Editors and Admins in any paid InstaCharts workspace. Your team can build sheets and charts together in one shared workspace, with each person's access set by their role.
How it works
  • Open Members in your workspace's left sidebar and click Invite Member. Enter their email address, choose a role and add an optional message.
  • Editors can create, edit and delete sheets and charts. Admins can do the same and can also manage members and workspace settings.
  • Each Editor and Admin uses one seat at your workspace's plan price: $10 per user per month on Starter and $19 per user per month on Pro. Each paid workspace can also include up to 5 Viewers for free.
  • A seat is added to your subscription as soon as someone joins as an Editor or Admin. When someone leaves or moves to Viewer, the unused time is credited to your next invoice.
  • You can change a member's role or remove them at any time from the Members tab.
More capacity as your team grows
  • Every seat adds your plan's monthly tasks and AI credits to a shared pool that everyone in the workspace can use.
  • Editors work with your workspace's plan limits for rows, columns, file size and storage, even when their own account is on the Free plan.
Learn more in the Workspace Members docs.
New feature! Keep your dashboards and charts in sync with offline data. Update your InstaCharts sheet with newer versions of your file from your device.
This is helpful for keeping your charts in sync with an offline excel spreadsheet.
More dashboard themes are now available (including several dark themes!) These new dashboard themes match the recently released chart themes - so your dashboards and charts can match.
Read more: Dashboard Themes
Load More
→