--- title: "Create charts from spreadsheets" description: "Turn a spreadsheet or CSV into a KPI card, bar chart, or line chart with the source data ready to inspect and download." canonical: "https://bearly.ai/docs/features/charts/" markdown: "https://bearly.ai/docs/features/charts.md" --- # Create charts from spreadsheets HTML: [https://bearly.ai/docs/features/charts/](https://bearly.ai/docs/features/charts/) > Turn a spreadsheet or CSV into a KPI card, bar chart, or line chart with the source data ready to inspect and download. 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](https://bearly.ai/docs/features/code-interpreter.md) to summarize a spreadsheet before charting it. In the desktop app, you can instead use [Work locally](https://bearly.ai/docs/features/work-locally.md) and approve the required file and command actions. ## Create a chart 1. **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. 2. **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. 3. **Name the comparison or decision** Tell Bearly which values to calculate, how to group them, and which chart form you want. For example: ```text copy 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. 4. **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](https://bearly.ai/docs/features/artifacts.md) or use [Code Interpreter](https://bearly.ai/docs/features/code-interpreter.md) 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](https://bearly.ai/docs/features/code-interpreter.md) is available. In the desktop app, you can turn on [Work locally](https://bearly.ai/docs/features/work-locally.md) 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**. ## Continue through the documentation - [Documentation index](https://bearly.ai/docs.md): Browse every Bearly guide. - [Previous: Create and edit videos](https://bearly.ai/docs/features/video-generation.md) - [Next: Create interactive AI artifacts with Pages](https://bearly.ai/docs/features/artifacts.md) - [Related: Analyze data with Code Interpreter](https://bearly.ai/docs/features/code-interpreter.md) - [Related: Work with local files](https://bearly.ai/docs/features/work-locally.md)