A cross-platform command-line tool converting Markdown + SQL into plain editable PowerPoint presentations with charts, powered by DuckDB.
## Page views of ${year}-${month}
<?plotance rows: 1:48pt ?>
```plotance
format: line
x_axis_label_format: d
x_axis_major_unit: 7 days
legend_position: none
query: |
SELECT
date_trunc('day', timestamp) AS date,
COUNT(*) AS count
FROM
read_csv(
'access_'
|| getvariable('year')
|| '-'
|| getvariable('month')
|| '.csv.gz'
)
GROUP BY ALL
ORDER BY ALL;
```
We are growing!↓
plotance --arg year=2025 --arg month=01 --template theme.pptx pageviews.md↓
See other examples and user guide for usage.
- Run
dotnet buildto build the project. - Run
dotnet publishto create a single binary executable. - Run
create_release_archives.ps1in PowerShell to create release ZIP archives for all platforms.
This project is released under the MIT License.
2025 Plotance contributors https://plotance.github.io/
See MIT.txt for more details.