> 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/reference/auto-charts.md).

# Auto Charts

### Full Auto-Detection Reference

When you have not specified `@chart`, ChartSQL will automatically choose a chart type when the following columns of the specified data types exist in the result set. 

<table data-full-width="false"><thead><tr><th width="238">Default Chart Type</th><th>Non-numeric Columns</th><th>Date Columns</th><th>Datetime Columns</th><th>Numeric Columns</th><th>X-axis</th><th>Y-axis</th><th>Additional Axis/Property</th><th>Rule</th></tr></thead><tbody><tr><td>Column</td><td>1</td><td>0</td><td>0</td><td>1</td><td>Non-numeric</td><td>Numeric</td><td></td><td>1</td></tr><tr><td>Grouped Column</td><td>1</td><td>0</td><td>0</td><td>2 or more</td><td>Non-numeric</td><td>Numeric</td><td></td><td>2</td></tr><tr><td>Date-based Line</td><td>0</td><td>1</td><td>0</td><td>1 or more</td><td>Date</td><td>Numeric</td><td></td><td>3</td></tr><tr><td>Datetime based line</td><td>0</td><td>0</td><td>1</td><td>1 or more</td><td>Datetime</td><td>Numeric</td><td></td><td>4</td></tr><tr><td>Stacked-Grouped Column</td><td>2 or more</td><td>0</td><td>0</td><td>2</td><td>Non-numeric 1</td><td>Numeric</td><td>Non-numeric 2 (subcategories)</td><td>5</td></tr><tr><td>Scatter</td><td>0</td><td>0</td><td>0</td><td>2</td><td>Numeric 1</td><td>Numeric 2</td><td></td><td>6</td></tr><tr><td>Bubble (scatter with size)</td><td>0</td><td>0</td><td>0</td><td>3</td><td>Numeric 1</td><td>Numeric 2</td><td>Numeric 3 (bubble size)</td><td>7</td></tr><tr><td>Heatmap</td><td>2</td><td>0</td><td>0</td><td>1</td><td>Non-numeric 1</td><td>Non-numeric 2</td><td>Numeric (color intensity)</td><td>8</td></tr></tbody></table>