Create charts from spreadsheets

View as markdown

Attach a spreadsheet or CSV and ask Bearly to turn the relevant rows into a KPI card, bar chart, or line chart. The chart stays in the conversation with the summarized data it was drawn from.

Charts works in Bearly chats on the web, desktop, iOS, and Android. Bearly usually needs Code Interpreter to summarize a spreadsheet before charting it. In the desktop app, you can instead use Work locally and approve the required file and command actions.

Create a chart

Attach the source file

Select the plus icon → Attach files, or drag a spreadsheet or CSV into the chat. You can also use a file that is already in the conversation.
Choose Chart

Type /chart, then select Chart under Tools. You can also ask for a chart in ordinary language when the source file and desired result are clear.
Name the comparison or decision

Tell Bearly which values to calculate, how to group them, and which chart form you want. For example:
```
Compare quarterly revenue by region as a grouped bar chart. Use USD, sort the quarters in date order, and keep the summarized data with the chart.
```
Bearly calculates the summary in code, saves it as a CSV, and draws the chart from that file. If you use Work locally, review and approve each requested file or command action.
Check the chart and its data

The result appears in a card labeled Chart. Move the pointer across a bar or line chart to inspect the nearest value. On a touch screen, tap the plot to keep that value visible.

Select View data to open the summarized rows behind the chart, then View chart to return. Every chart includes Download CSV. Bar and line charts also include Download PNG.

Choose the right result

Charts supports these result types:

KPI card — one value with an optional goal and progress indicator.
Bar chart — one series, grouped series, or stacked series across categories.
Line chart — one or more series across dates or ordered labels.

Ask for a table when you need row-level records. Ask for a pivot table when the grouped table itself is the result. Those stay as downloadable files instead of being forced into a chart.

For a dashboard, calculator, map, pie chart, scatter plot, or another interactive layout, ask Bearly for a Page or use Code Interpreter to create a separate file.

Data limits

Bearly charts summarized data rather than a large raw export:

A KPI uses exactly one summary row.
A bar chart supports up to 100 rows and 30 categories.
A line chart supports up to 2,000 rows and 12 series.
The summarized CSV can contain up to 10 columns and must be 2 MB or smaller.

Bearly does not silently sample or cut off rows to make a chart fit. If the summary is too large or contains duplicate category-and-series pairs, it must rebuild the summary before trying again.

If a chart does not appear

What you see	What to do
`/chart` does not offer Chart	Check for a Bearly update. On a managed account, ask a team administrator whether the policy allows Charts.
Bearly cannot prepare the spreadsheet	Confirm that the source file is attached and Code Interpreter is available. In the desktop app, you can turn on Work locally and approve the requested actions instead.
Bearly reports missing fields, duplicate values, or too much data	Ask it to rebuild a smaller summary with one row per category and series pair, then create the chart again.
The chart could not load. The data is available below.	Review or download the CSV shown in the fallback. Ask Bearly to create the chart again if the data is correct.
The chart says its source no longer exists	Attach the source file again and ask Bearly to rebuild the chart.

Managed-team administrators control Charts from Teams → team name → Policies → policy name → Media & Creativity → Charts.