Guides / Charts with ChatGPT and Claude
Make charts with ChatGPT, Claude and Claude Code
AI is great at the dull part of a chart: finding the numbers, cleaning them up and putting them in a table. MakeYourChart does the rest: the animation, the design and the video. Connect the two and you can ask for a chart in plain words and get one back, from public data, a file, a code repo or your own database.
1. Connect MakeYourChart to your AI
MakeYourChart is an MCP connector, the standard way AI apps plug into other tools. There's no account or key to set up. Add this URL:
https://makeyourchart.com/mcp
- Claude (web, desktop and mobile)
- Open Customize → Connectors (on older versions, Settings → Connectors), click +, choose Add custom connector, name it MakeYourChart and paste the URL. Leave the advanced settings empty. Works on every plan, including Free. Team and Enterprise owners add it under Organization settings → Connectors.
- ChatGPT
- On chatgpt.com open Settings → Apps & Connectors → Advanced settings and turn on Developer mode (paid plans). Click Create, name it MakeYourChart, paste the URL and pick No authentication. In a chat, click +, choose Developer mode and switch MakeYourChart on.
- Claude Code
- Run this once in your terminal. Every project can then make charts.
claude mcp add --transport http makeyourchart https://makeyourchart.com/mcp
- Codex
- Run this once in your terminal.
codex mcp add makeyourchart --url https://makeyourchart.com/mcp
- Cursor, Windsurf and other editors
- Add this to the editor's MCP settings (in Cursor, ~/.cursor/mcp.json). VS Code uses "servers" in place of "mcpServers" and adds "type": "http".
{ "mcpServers": { "makeyourchart": { "url": "https://makeyourchart.com/mcp" } } }
2. Ask for a chart
Say what you want to show and where the numbers are. The AI gathers and shapes the data, then sends back a link. Open it and the chart is already playing in the editor, ready to tweak and download as an MP4.
- Public data
Make a bar chart race of the 10 most populous countries from 1960 to today using World Bank data. Add captions for China's one-child policy and India passing China.
- A file you attach
Here's our Stripe export. Make a running total of revenue by plan, by month, in our brand colors #FF5A1F and #111827.
- Your database (Claude Code, Codex, Cursor)
Query the orders table for revenue per product per month in 2025 and make a line race. Title it 2025 in one chart, square format for LinkedIn.
- A code repo
Go through this repo's git history and make a bar race of commits per contributor per month since the first commit.
- A web page
Turn the table on the Wikipedia page for the best-selling music artists into a ranking chart, with the source line.
Charts from your own data
Coding assistants like Claude Code, Codex and Cursor can read the files in a project and run queries against a database you've given them access to. Ask for the chart and they write the query, run it and send the result to MakeYourChart. If you'd rather write the query yourself, return one row per date and item, like this, and paste the result into the editor:
-- one row per month and product: the editor reads Date, Name, Value directly
SELECT to_char(date_trunc('month', created_at), 'YYYY-MM') AS date,
product_name AS name,
sum(amount) AS value
FROM orders
GROUP BY 1, 2
ORDER BY 1;A plain export works too. Lists of sales, sign-ups or donations with any number of columns are added up for you. See how to format your data for every layout the editor reads.
No connector? Copy this prompt
In any AI chat, including the free versions of ChatGPT and Claude, paste this prompt with your data (or a description of the data you want). Copy the table it sends back into the Data box in the editor.
Turn the data below into a CSV for an animated chart on makeyourchart.com. Rules: - First row is the header. First column is the time: years (2020), months (2024-03) or dates (2024-03-15). - Then one column for each thing being compared (a country, a product, a person). Keep names short and spelled the same every time. - Plain numbers only: no $, %, commas or units in the cells. Leave a cell empty if a value is missing. Never make numbers up. - If there are no dates, use two columns: Name, Value. - Keep the 5 to 15 most important items. Leave out totals and averages. - Reply with only the CSV in one code block, then one line saying where the numbers come from. Data: [paste your data or attach a file, or describe what you want, like "the 10 biggest companies by market cap each year since 2000"]
What makes a chart look great
- 5 to 15 items, 10 or more dates
- That's what gives a race its overtakes. Two dates make a slide, not a race. Monthly or yearly steps both work.
- Lead with the hook
- Title it with the surprise (“The year TikTok passed Instagram”), not the dataset name.
- Name the source
- A source line at the bottom makes people trust the chart and share it. Ask the AI to include it.
- Three or four captions
- Short notes that pop up at key moments (a crash, a launch, an overtake) keep people watching to the end.
- Your brand
- Give the AI your brand hex colors and it applies them. Pro adds your logo or @handle in place of the watermark.
- Pick the shape for where it goes
- 9:16 for Reels, TikTok and Shorts, 4:5 for the Instagram feed, 1:1 for LinkedIn, 16:9 for YouTube and slides.
Questions
Is the connector free?
Yes. Anyone can connect it and make charts. Videos download free at 720p with a small watermark. Pro ($11.99/month) removes the watermark and adds 1080p and 4K, 60 fps, your logo and music.
Do I need to know how to code?
No. You ask in plain words. The AI writes any queries or code it needs, and the chart opens in the editor where you change things by clicking.
What happens to my data?
When your AI uses the connector, it sends the chart's table and settings to us. We save them under a private, unguessable link so the chart can open, and delete the link's data after 30 days. We don't list, share or reuse it. Data you paste into the editor yourself stays in your browser.
Which AI apps work?
Anything that supports MCP connectors: Claude, ChatGPT (developer mode), Claude Code, Codex, Cursor, Windsurf, VS Code and others. If yours doesn't, use the copy-and-paste prompt above.
Which charts can it make?
Bar chart races, line races, column races, donut races, stacked area races, 100% share races, head-to-head tug of wars and big counting numbers, in six looks and four video shapes.
The chart looks wrong. What now?
Tell the AI what's off (“the names and dates are swapped”, “use monthly data”). It gets a note back on how the data was read, so it can fix it and send a new link. You can also edit the data box in the editor directly.