> 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/bar.md).
# Bar
## Basic Bar Chart
```sql
-- @chart: bar
-- @title: Bar Chart
-- @subtitle: An basic example of a bar chart
SELECT
Channel,
count(*) as Won_Sales
FROM Sales
WHERE Status = 'Won'
GROUP BY Channel
ORDER BY Won_Sales DESC;
```
An example of a bar chart
| CHANNEL | WON\_SALES |
| -------- | ---------- |
| pr\_ad | 21.0 |
| coldcall | 37.0 |
| search | 66.0 |
| event | 112.0 |
| referral | 243.0 |
## Bar chart with Parent and Sub Category Groups
```sql
-- @chart: bar
-- @title: Groups - Multiple category groups
-- @subtitle: An example of multiple category groups
-- @groups: Channel, Owner
-- @series: TotalSales
-- @formats: currency
SELECT
Final.*
FROM (
SELECT
Channel,
Owner,
(
SELECT sum(Sub.Amount)
FROM Sales Sub
WHERE Sub.Channel = Sales.Channel
) as TotalChannelSales,
sum(Amount) as TotalSales
FROM Sales
WHERE Owner IN (
SELECT Owner
FROM Sales
GROUP BY Owner
ORDER BY sum(Amount)
LIMIT 10
)
GROUP BY Channel, Owner
) as Final
ORDER BY TotalChannelSales DESC, TotalSales DESC
```
An example bar chart with group parent and sub category
| CHANNEL | OWNER | TOTALCHANNELSALES | TOTALSALES |
| -------- | ------- | ----------------- | ---------- |
| pr\_ad | Kim | 9181300.0 | 84603.0 |
| pr\_ad | Roger | 9181300.0 | 118985.0 |
| pr\_ad | Lucy | 9181300.0 | 138374.0 |
| pr\_ad | Norbit | 9181300.0 | 141711.0 |
| pr\_ad | Justice | 9181300.0 | 160517.0 |
| pr\_ad | Heather | 9181300.0 | 239870.0 |
| pr\_ad | Peter | 9181300.0 | 266655.0 |
| pr\_ad | Tammy | 9181300.0 | 501805.0 |
| coldcall | Justice | 1.7372264E7 | 87207.0 |
| coldcall | Heather | 1.7372264E7 | 162974.0 |
| coldcall | Norbit | 1.7372264E7 | 333648.0 |
## Bar Chart with Formats
```sql
-- @chart: bar
-- @title: Bar Chart With Formats
-- @subtitle: An example bar chart with formats
-- @formats: currency
SELECT
Channel,
sum(Amount) as Total_Sales
FROM Sales
WHERE Status = 'Won'
GROUP BY Channel
ORDER BY Total_Sales DESC;
```
An example bar chart with specified currency format
| CHANNEL | TOTAL\_SALES |
| -------- | ------------ |
| pr\_ad | 1716590.0 |
| coldcall | 3267837.0 |
| search | 6320993.0 |
| event | 1.1198055E7 |
| referral | 2.6029056E7 |
## Bar with Stacking
```sql
-- @chart: bar
-- @title: Bar Stacking - Example bar chart with stacking
-- @groups: Owner, Channel
-- @subtitle: An example bar chart that has a single stack
-- @formats: currency
-- @series: Sales
-- @stacks: Channel
SELECT *
FROM (
SELECT
Owner,
Channel,
(
SELECT sum(Amount)
FROM Sales Sub
WHERE Sub.Owner = Sales.Owner
) as OwnerTotal,
sum(amount) as Sales
FROM sales
GROUP BY Owner, Channel
) as Final
ORDER BY Final.OwnerTotal ASC, Sales DESC;
```