\r \r

ChartGen AI Chart Generator\r

\r AI-powered chart generator that creates professional visualizations through natural language. Built on ChartGen AI engine.\r \r

Overview\r

\r Transform your data into stunning, interactive charts with simple natural language commands. No coding required - just describe the chart you want, and ChartGen AI generates it instantly.\r \r This skill supports Text-to-Chart, Text-to-SQL, and Text-to-Data analysis. Simply provide Excel/CSV files or JSON data, describe your visualization needs in plain language, and get interactive ECharts visualizations, structured analysis reports, and AI-driven insights.\r \r Powered by ChartGen AI engine, supporting multiple chart types including bar, line, pie, scatter, area, and more. Optimized for business analytics and data storytelling.\r \r API Service: This skill uses the ChartGen API service hosted at chartgen.ai. All data is sent to https://chartgen.ai/api/platform_api/ for processing.\r \r ---\r \r

Quick Start\r

\r

1. Apply for an API Key\r

\r You can easily create and manage your API Key at chartgen.ai. To begin with, you need to register for an account.\r \r Steps:\r

1. Visit chartgen.ai and sign up for an account\r
2. Access the API management dashboard\r
3. Create a new API and set the credit consumption limit\r
4. Copy the API Key for use\r \r

2. Configure Environment Variable\r

\r

export CHARTGEN_API_KEY="your-api-key-here"\r
```\r
\r
### 3. Run Scripts\r
\r
```bash\r
# Generate Chart (Text-to-Chart)\r
python scripts/data_visualization.py --query "Draw a bar chart of sales by region" --file sales.xlsx\r
\r
# Data Analysis\r
python scripts/data_analysis.py --query "Calculate total sales by region" --file sales.xlsx\r
\r
# Data Interpretation\r
python scripts/data_interpretation.py --query "Analyze sales trends" --file sales.xlsx\r
```\r
\r
---\r
\r
## Credit Rules\r
\r
- Calling a single tool consumes 20 credits\r
- You get 200 free credits per month for free accounts\r
- When credits run out, you can purchase more or upgrade your account on the [chartgen.ai Billing page](https://chartgen.ai/billing)\r
\r
---\r
\r
## Scripts Reference\r
\r
| Script | Function | Use Case |\r
|--------|----------|----------|\r
| `data_visualization.py` | Chart Generation | Text-to-Chart, create bar/line/pie/scatter charts |\r
| `data_analysis.py` | Data Analysis | Statistics, filtering, aggregation, calculation |\r
| `data_interpretation.py` | Insight Generation | Trend analysis, pattern discovery, report generation |\r
\r
---\r
\r
## Parameters\r
\r
### Common Parameters\r
\r
| Parameter | Required | Description |\r
|-----------|----------|-------------|\r
| `--query` | Yes | Natural language query statement |\r
| `--file` | No | Local file path (.xlsx/.xls/.csv), mutually exclusive with --json |\r
| `--json` | No | JSON data (string or file path), mutually exclusive with --file |\r
\r
### Visualization Specific Parameters\r
\r
| Parameter | Description |\r
|-----------|-------------|\r
| `--output, -o` | Output HTML file path (defaults to /tmp/openclaw/charts/) |\r
\r
---\r
\r
## Data Format\r
\r
### File Format\r
\r
Supports `.xlsx`, `.xls`, `.csv` Excel and CSV files.\r
\r
Note: Only one of --file or --json is needed. If both are provided, --file takes precedence. File types support both row-metric-column data files and column-metric-row data files.\r
\r
### JSON Format\r
\r
JSON data should be an array format, where each element is a row of data:\r
\r
```json\r
[\r
  {"name": "Product A", "sales": 1000, "region": "East"},\r
  {"name": "Product B", "sales": 1500, "region": "North"},\r
  {"name": "Product C", "sales": 800, "region": "South"}\r
]\r
```\r
\r
Or pass via file:\r
\r
```bash\r
python scripts/data_visualization.py --query "Draw a chart" --json data.json\r
```\r
\r
---\r
\r
## Usage Examples\r
\r
### Chart Generation (Text-to-Chart)\r
\r
```bash\r
# Bar chart\r
python scripts/data_visualization.py --query "Draw a bar chart of sales by product" --file sales.xlsx\r
\r
# Line chart\r
python scripts/data_visualization.py --query "Draw a line chart of sales trends" --file trends.xlsx\r
\r
# Pie chart\r
python scripts/data_visualization.py --query "Draw a pie chart of sales by region" --file sales.xlsx\r
\r
# Scatter plot\r
python scripts/data_visualization.py --query "Draw a scatter plot of price vs quantity" --file data.xlsx\r
\r
# Save to specific path\r
python scripts/data_visualization.py --query "Draw a bar chart" --file data.xlsx -o /path/to/chart.html\r
```\r
\r
### Data Analysis\r
\r
```bash\r
# Statistical calculation\r
python scripts/data_analysis.py --query "Calculate total and average sales by region" --file sales.xlsx\r
\r
# Data filtering\r
python scripts/data_analysis.py --query "Filter products with sales greater than 1000" --file sales.xlsx\r
\r
# Sorting\r
python scripts/data_analysis.py --query "Sort by sales in descending order" --file sales.xlsx\r
```\r
\r
### Insight Generation\r
\r
```bash\r
# Trend analysis\r
python scripts/data_interpretation.py --query "Analyze monthly sales trends" --file monthly_sales.xlsx\r
\r
# Anomaly detection\r
python scripts/data_interpretation.py --query "Find and explain anomalies in the data" --file data.xlsx\r
\r
# Comprehensive interpretation\r
python scripts/data_interpretation.py --query "Provide a comprehensive analysis with key insights" --file report.xlsx\r
```\r
\r
---\r
\r
## Supported Chart Types\r
\r
- Bar Chart / Stacked Bar Chart\r
- Line Chart / Area Chart\r
- Pie Chart / Donut Chart\r
- Scatter Plot\r
- And more...\r
\r
---\r
\r
## Output Description\r
\r
### Chart Generation\r
\r
1. **Console Output**: ECharts configuration JSON\r
2. **HTML File**: Interactive chart that can be opened in any browser\r
\r
### Data Analysis & Insight Generation\r
\r
Returns Markdown format text results, including analysis conclusions, data tables, and insights.\r
\r
---\r
\r
## Error Handling\r
\r
Common errors and solutions:\r
\r
| Error Message | Cause | Solution |\r
|---------------|-------|----------|\r
| `CHARTGEN_API_KEY not set` | Environment variable not set | `export CHARTGEN_API_KEY="your-key"` |\r
| `API request timeout` | Request timeout | Check network connection and retry |\r
| `File not found` | File does not exist | Check if file path is correct |\r
| `credits are insufficient` | Insufficient credits | Recharge or contact administrator |\r
\r
---\r
\r
## Technical Details\r
\r
- **API Base URL**: `https://chartgen.ai/api/platform_api/`\r
- **Authentication**: Header `Authorization: \x3Capi-key>`\r
- **Request Format**: JSON\r
- **Timeout**: 60 seconds\r
- **Required Environment Variable**: `CHARTGEN_API_KEY`\r
\r
See `scripts/chartgen_api.py` for implementation details.\r
\r
---\r
\r
## Privacy Notice\r
\r
**Data sent to remote API**: This skill reads your provided data files (CSV/XLSX/JSON), base64-encodes them, and sends them to the ChartGen API at `https://chartgen.ai/api/platform_api/` for analysis and chart generation. Your data will leave your machine.\r
\r
**Recommendations**:\r
- Do not upload sensitive or regulated data\r
- Use a dedicated API key with limited scope/credits\r
- Review the privacy practices at [chartgen.ai](https://chartgen.ai) before use\r