~/.openclaw/workspace/.venv_chart/bin/python skills/chart-mpl/scripts/chart_mpl.py \
  --csv /path/to/data.csv \
  --xcol Mois \
  --ycol Valeur \
  --kind line \
  --title "Monthly trend" \
  --xlabel "Month" \
  --ylabel "Value"

Output defaults to: ~/.openclaw/workspace/exports/images

Inputs

--csv path to CSV file
--xcol column for X axis
--ycol numeric column(s) for Y axis — comma-separated for multi-series (e.g. Sales,Costs)
--kind chart type: line, bar, hbar, pie, stacked, scatter, area
Optional: --delim if auto-detection fails (;, ,, \t, |)
Optional: --out custom output path (PNG or SVG — format detected from extension)
Optional: --title, --xlabel, --ylabel
Optional: --top N show only top N categories by value (bar, hbar, pie, stacked). Multi-series ranks by row total.
Optional: --sort sort data before plotting: x-asc, x-desc, y-desc, none (default: none)
Optional: --numfmt number format on Y axis: fr (1,5M) or en (1.5M) — default: fr

Chart types

Kind	Description	Multi-series
`line`	Line chart with markers	yes
`bar`	Vertical bar chart (grouped when multi-series)	yes
`hbar`	Horizontal bar chart (grouped when multi-series)	yes
`pie`	Pie chart (first Y column only)	no
`stacked`	Stacked vertical bar (requires 2+ Y)	yes
`scatter`	Scatter plot	yes
`area`	Filled area chart	yes

Notes

Script auto-detects delimiters when possible.
Script tolerates European and US numeric formats (1 234,56, 1,234.56).
Non-numeric values in ycol are converted to NaN with a warning.
Handles BOM-encoded CSV files (utf-8-sig).
Multi-series charts automatically show a legend and cycle through an 8-color palette.
Y-axis ticks use human-readable formatting (K, M, G suffixes) with French or English decimals.
--top N keeps the N highest categories. For pie charts, the remainder is aggregated into an "Other" slice. For bar/hbar/stacked, the rest are excluded.
Output format (PNG or SVG) is detected from the --out file extension. Default is PNG.

End-to-end flow with SQL skill

Export query result to CSV using the mssql skill.
Run this script on that CSV.
Share the generated PNG path.

chart-mpl

Chart MPL

Setup

Quick start