Create and update charts in GridOS with AI

Ask GridOS to generate bar, line, or pie charts from your grid data — and update them in place by describing the change you want.

GridOS renders charts as overlays directly on the grid using Chart.js. You create and modify them the same way you do everything else in GridOS: by describing what you want in the chat. The AI reads the current grid, selects an appropriate data range and anchor cell, and produces the chart automatically.

Create a chart by asking

Open the chat panel and describe the chart you want. You don’t need to specify a data range — the agent reads the grid and picks one.

Create a bar chart of the quarterly revenue data

Add a line chart showing monthly expenses vs. actuals

Make a pie chart of the market share breakdown in column B

The agent fills a chart_spec alongside any cell writes. When you click Apply, GridOS renders the chart as an overlay anchored to the grid cell you specified (or one the agent chose for you).

Chart types

GridOS supports three chart types:

Bar

Best for comparing values across categories — quarters, products, cost centers.

Line

Best for time series — monthly revenue trends, rolling averages, multi-period forecasts.

Pie

Best for part-to-whole breakdowns — market share, budget allocation, segment mix.

How the agent picks data range and anchor

When you ask for a chart, the agent inspects the full grid state and decides:

• data_range — the rectangular range covering both labels and values (for example, A1:B6)
• anchor_cell — the top-left cell where the chart overlay appears; the agent picks an empty area of the grid so the chart doesn’t sit on top of your data
• orientation — columns means the first column contains labels (typical for most models); rows means the first row contains labels

You can override any of these by being explicit in your prompt: “create a bar chart of A1:D10 anchored at F2 using the first row as labels.”

Update an existing chart

To move, retype, or resize a chart, describe the change you want. GridOS matches the chart by its title and updates it in place — it does not create a duplicate.

Move the revenue chart to F16

Change the scores chart to a pie chart

Resize the quarterly expenses chart to anchor at H2

When updating an existing chart, refer to it by the exact title it was created with (for example, “the revenue chart” or “Quarterly Revenue”). If the title doesn’t match, the agent creates a new chart instead of updating the existing one.

The agent reuses the same title in chart_spec, and GridOS upserts the chart in place — the chart ID stays the same, only the properties change.

Chart data orientation

The orientation field controls how GridOS interprets your data range:

columns (default)

The first column of the range contains category labels. Subsequent columns are data series. This is the standard layout for most GridOS financial models.

A1: Quarter   B1: Revenue   C1: Expenses
A2: Q1        B2: 100       C2: 60
A3: Q2        B3: 110       C3: 65
A4: Q3        B4: 121       C4: 70

Data range A1:C4, orientation columns.

rows

The first row of the range contains category labels. Subsequent rows are data series. Use this when your data is laid out horizontally.

A1: Quarter   A2: Revenue   A3: Expenses
B1: Q1        B2: 100       B3: 60
C1: Q2        C2: 110       C3: 65
D1: Q3        D2: 121       D3: 70

Data range A1:D3, orientation rows.

Create a chart manually

You can also create charts directly from the UI without using the chat:

1. Select your data

   Click and drag to highlight the cells you want to chart, including the label column or row.

2. Open the chart dialog

   Use the Insert menu or the chart toolbar button to open the chart creation panel.

3. Configure and insert

   Choose the chart type, confirm the data range, and set the anchor cell. Click Create to render the chart overlay.

Manage charts

Delete a chart

Ask the agent to remove it (“delete the revenue chart”) or use the chart’s close button in the UI to remove it from the grid.

Charts across sheets

Each chart belongs to the sheet it was created on. Switching to a different sheet tab hides the charts from other sheets and shows only the charts for the active sheet.

Chart persistence

Charts are saved as part of your workbook state. When you export a .gridos file or save the workbook, all charts on every sheet are included.