> For the complete documentation index, see [llms.txt](https://docs.chartsql.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.chartsql.com/charts/scatter.md).

# Scatter

<table data-card-size="large" data-view="cards"><thead><tr><th data-card-target data-type="content-ref"></th><th data-hidden></th><th data-hidden></th><th data-hidden></th><th data-hidden data-card-cover data-type="files"></th></tr></thead><tbody><tr><td><a href="/pages/CkH1XHlry5PfhfWmAH1o#auto-scatter">/pages/CkH1XHlry5PfhfWmAH1o#auto-scatter</a></td><td></td><td></td><td></td><td><a href="/files/5ODCcwMzGVTaCKbIln3P">/files/5ODCcwMzGVTaCKbIln3P</a></td></tr></tbody></table>

## Auto Scatter

When 2 numeric columns exist

```sql
-- @title: Auto Scatter - Sales by Profit
-- @subtitle: Auto generted scatter chart
SELECT 
  Profit,
  Amount
FROM Sales
WHERE Status = 'Won';
```

<figure><img src="/files/5ODCcwMzGVTaCKbIln3P" alt=""><figcaption><p>An example scatter chart</p></figcaption></figure>

| PROFIT  | AMOUNT   |
| ------- | -------- |
| 27064.0 | 84572.0  |
| 45307.0 | 133253.0 |
| 14746.0 | 73728.0  |
| 21198.0 | 75705.0  |
| 37394.0 | 196808.0 |
| 15454.0 | 67191.0  |
| 13263.0 | 78013.0  |
| 11532.0 | 76878.0  |
| 13092.0 | 72732.0  |
| 25484.0 | 63708.0  |

##
