Immediate result: The best chart for your data and message, with labelling advice and a mock-up in text.
Problem it solvesThe wrong chart hides the point — pie charts with twelve slices, dual axes that mislead.
Revenue by 9 product lines for 2025 vs 2026 · message: 3 lines drove all the growth
Chart: slope chart (or sorted dot plot), 9 lines, 2025 → 2026.
Why not grouped bars: 18 bars make the 3 winners hard to spot.
Title: 'Three product lines drove all of 2026's growth' · colour only those three.
The wrong chart hides the point: twelve-slice pie charts, misleading dual axes, bars nobody can compare. This skill identifies what kind of comparison your data makes — over time, ranking, part-to-whole, distribution or relationship — recommends one chart and explains why the obvious alternative is worse. It specifies axes, sorting, colour emphasis and a title that states the message, then gives the code in Python or the steps in Excel or Google Sheets. Your audience gets the point in seconds instead of squinting. To use it, paste the skill into your assistant and send a sample of your data (columns and a few rows) and the one message you want the audience to get.
# Skill: Chart picker
You are running the "Chart picker" skill for me. I work as: Analyst presenting data. What I need from you: the best chart for my data and message, with labelling advice and a mock-up in text.
## When I send you a sample of my data (columns and a few rows) and the one message I want the audience to get
1. Identify the comparison type: over time, ranking, part-to-whole, distribution, relationship.
2. Recommend one chart and say why the obvious alternative is worse.
3. Specify axes, sorting, colour emphasis and title (the title states the message).
4. Give the code for the chart in Python or the steps in Excel/Sheets.
## Reply in this format
- Recommended chart
- Why not the alternative
- Spec
- Code or steps
## Rules
- Use only the facts I give you; mark anything you had to assume with [ASSUMPTION].
- If something essential is missing, ask me one short question, then continue.
- No preamble or filler: start with the result.
Confirm you're ready in one line, then wait for me to send a sample of my data (columns and a few rows) and the one message I want the audience to get.Then sendA sample of your data (columns and a few rows) and the one message you want the audience to get. For example: Revenue by 9 product lines for 2025 vs 2026 · message: 3 lines drove all the growth
Upload it to Claude, add it to ChatGPT's Codex app, clone it into Claude Code, or download the SKILL.md for any agent. Full guide with screenshots →
Download the ZIP and upload it in Claude. Claude then uses the skill on its own whenever a request matches.
Download ZIP
OpenAI's Codex app reads the same SKILL.md format. Copy the skill into your Codex skills folder:
$ git -c http.version=HTTP/1.1 clone https://scienceofapps.com/skills/ai-skills.git
$ cp -r ai-skills/chart-recommender ~/.codex/skills/
Clone the library and copy this skill into your Claude Code skills folder.
$ git -c http.version=HTTP/1.1 clone https://scienceofapps.com/skills/ai-skills.git
$ cp -r ai-skills/chart-recommender ~/.claude/skills/~/.claude/skills/ for all projects, or .claude/skills/ inside one project.Download the skill file and put it in a folder named after the skill.
Download SKILL.md~/.claude/skills/chart-recommender/SKILL.md.Repositoryscienceofapps.com/skills/ai-skills.git · all 200 skills, one folder each, plain git over HTTPS
The wrong chart hides the point — pie charts with twelve slices, dual axes that mislead. The skill fixes that: the best chart for your data and message, with labelling advice and a mock-up in text.
Copy the skill and paste it as the first message of a new chat, then send your input. To keep it, paste it into a ChatGPT Project or custom GPT, a Claude Project or a Gemini Gem, or upload the SKILL.md file as a Claude Skill.
Send a sample of your data (columns and a few rows) and the one message you want the audience to get. If something essential is missing, the skill asks you one short question and then continues.
Yes. It's free to copy, use and adapt, with no sign-up, and works in the free versions of ChatGPT, Claude, Gemini and Copilot.
ProblemA retention table full of percentages doesn't tell you what's improving or why.
Monthly cohorts Jan–Jun 2026, months 0–5
Biggest drop: month 0 → 1 (100% → 38%).
Improving: May and June cohorts keep 46% at month 1 vs 34% for Jan.
Flattens at ~22% from month 3 — a real core, worth growing.
Immediate resultA plain-English read of your cohort table: where users drop, which cohorts improved and what to test.
ProblemRepeating the same analysis in a spreadsheet every week is slow and error-prone.
sales.csv (date, region, product, units, price) · weekly revenue by region + chart
df['revenue'] = df.units * df.price
weekly = df.groupby([pd.Grouper(key='date', freq='W-MON'), 'region']).revenue.sum().unstack()
weekly.plot(); plt.savefig('weekly_revenue.png', dpi=200)
Immediate resultA commented pandas script that loads your file, does the analysis and saves a chart and summary.
ProblemA key number dropped overnight and everyone has a theory.
Checkout conversion fell from 3.1% to 2.2% on Tuesday
Check 1: did the analytics event or app version change Tuesday?
Decompose: sessions → add-to-cart → checkout start → payment success
If only Android 5.12 dropped: the release is the prime suspect.
Immediate resultA structured investigation plan that rules out data issues first, then segments to find the cause.
All 14 data & analytics skillsAll 200 skillsRead it in the articleProve it: AI for Data Analysts Certification (free test)
60 research-backed principles in 6 categories — what each one means, why it works on the human brain and how to use it on your own screens. Written by Sushant Singh, founder of Science of Apps, who has scaled consumer apps to lacs of users and spent 10+ years leading product across startups and digital businesses in the US, EU & India.
110 real paywalls from top apps, taken apart, rated out of 5 and decoded with the Laws of UX — plus the frameworks, copy and checklists to ship your own. By Sushant Singh, founder of Science of Apps.