> 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/line.md).
# Line
## Basic Line Chart
```sql
-- @chart: Line
-- @title: Line - Simple Line Chart
-- @subtitle: An example line chart with a detected category and series
-- @formats: currency
SELECT
TRUNC(date_closed, 'MONTH') as Month,
sum(amount) as Sales
FROM sales
GROUP BY Month
ORDER BY Month ASC;
```
An example date line chart
| MONTH | SALES |
| -------------------------------- | --------- |
| January, 01 2017 00:00:00 +0000 | 2668855.0 |
| February, 01 2017 00:00:00 +0000 | 3951547.0 |
| March, 01 2017 00:00:00 +0000 | 4403443.0 |
| April, 01 2017 00:00:00 +0000 | 3079040.0 |
| May, 01 2017 00:00:00 +0000 | 2576305.0 |
| June, 01 2017 00:00:00 +0000 | 3100093.0 |
| July, 01 2017 00:00:00 +0000 | 3112476.0 |
## Auto Line Chart
```sql
-- @title: Auto Line - Auto Generated Date Line Chart
-- @subtitle: An example chart which is auto detected to be a line
-- @formats: currency
SELECT
TRUNC(date_closed, 'MONTH') as Month,
sum(amount) as Sales
FROM sales
GROUP BY Month
ORDER BY Month ASC;
```
Example auto line chart
| MONTH | SALES |
| -------------------------------- | --------- |
| January, 01 2017 00:00:00 +0000 | 2668855.0 |
| February, 01 2017 00:00:00 +0000 | 3951547.0 |
| March, 01 2017 00:00:00 +0000 | 4403443.0 |
| April, 01 2017 00:00:00 +0000 | 3079040.0 |
| May, 01 2017 00:00:00 +0000 | 2576305.0 |
## Line with Series Title Spacing
```sql
-- @chart: Line
-- @title: Series Title Spacing
-- @subtitle: Spacing on series titles is determined by underscores
-- @formats: currency
SELECT
TRUNC(date_closed, 'MONTH') as Month,
sum(amount) as total_sales_amount
FROM sales
GROUP BY Month
ORDER BY Month ASC;
```
An example line chart with underscores converted to spaces in the series titles
| MONTH | TOTAL\_SALES\_AMOUNT |
| -------------------------------- | -------------------- |
| January, 01 2017 00:00:00 +0000 | 2668855.0 |
| February, 01 2017 00:00:00 +0000 | 3951547.0 |
| March, 01 2017 00:00:00 +0000 | 4403443.0 |
| April, 01 2017 00:00:00 +0000 | 3079040.0 |
| May, 01 2017 00:00:00 +0000 | 2576305.0 |
| June, 01 2017 00:00:00 +0000 | 3100093.0 |
| July, 01 2017 00:00:00 +0000 | 3112476.0 |
## Manual @Category and @series Line
```sql
-- @chart: line
-- @title: Manual Category and Series
-- @subtitle: An example chart manually setting the category and series
-- @category: Date_Closed
-- @series: Amount
SELECT
Sub.*,
(
SELECT channel
FROM Sales
WHERE Sales.Date_Closed = Sub.Date_Closed
GROUP BY Channel
ORDER BY count(*) DESC
LIMIT 1
) as TopChannel
FROM (
SELECT
Date_Closed,
sum(Amount) as Amount,
sum(Profit) as Profit
FROM Sales
WHERE Status = 'Won'
GROUP BY Date_Closed
ORDER BY Date_Closed ASC
) as Sub;
```
An example chart with a manually specified @category and @series