How to Make an X Y Graph with ChatGPT

You can absolutely create an XY graph right inside a conversation with ChatGPT. Using its built-in data analysis tools, you can turn raw numbers into a clear visualization without ever leaving the chat window. This article will show you exactly how to structure your data, what prompts to use, and how to refine your charts.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

First, What Exactly is an XY Graph?

An XY graph, also known as a scatter plot or a 2D plot, is one of the most fundamental charts in data analysis. Its job is to show the relationship between two sets of numerical data. One set of data is plotted on the horizontal X-axis, and the other is plotted on the vertical Y-axis. Each point on the graph represents a pair of values.

Think of it like this:

• The X-axis represents your independent variable - the thing you are controlling or observing (e.g., ad dollars spent).
• The Y-axis represents your dependent variable - the outcome that you measure, which might change based on the independent variable (e.g., website conversions).

Businesses use them constantly to spot trends, correlations, and outliers. For example, you might create an XY graph to see if higher ad spending (X) leads to more product sales (Y), or if more hours logged by a salesperson (X) result in a larger deal size (Y).

Getting Your Data Ready for ChatGPT

Before you can ask ChatGPT to make a chart, you need to prepare your data in a format it can easily understand. This is the most important step. If your data is messy or unclear, the graph will be wrong. The good news is, for a simple XY graph, the structure is very straightforward.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

Keep It Clean and Simple

You need a set of paired data points. The easiest way to format this for ChatGPT is a list or a simple comma-separated set of values. You can provide this in two main ways:

Option 1: Two Separate Lists

Provide one list for your X-axis values and a second for your corresponding Y-axis values.

X-axis values: [5, 12, 18, 25, 30]
Y-axis values: [20, 45, 62, 80, 95]

Option 2: Paired Values (Like a CSV)

Provide the data in pairs, where each pair represents (X, Y). This is often clearer for both you and the AI.

Month, Sales
Jan, 15000
Feb, 18000
Mar, 22000
Apr, 20000
May, 25000
Jun, 28000

A Practical Example: Tracking Marketing Campaign Performance

Let's imagine you've been running a digital marketing campaign for the past eight weeks. You want to see if there's a relationship between your weekly ad spend (your X variable) and the number of leads generated (your Y variable).

Here’s what your data looks like:

• Week 1: Spent $300, got 25 leads
• Week 2: Spent $500, got 42 leads
• Week 3: Spent $450, got 38 leads
• Week 4: Spent $700, got 65 leads
• Week 5: Spent $800, got 71 leads
• Week 6: Spent $650, got 58 leads
• Week 7: Spent $1000, got 90 leads
• Week 8: Spent $1100, got 95 leads

To give this to ChatGPT, we’ll clean it up into a simple format. We’ll label our columns clearly, so there’s no confusion.

Weekly Ad Spend ($), Leads Generated
300, 25
500, 42
450, 38
700, 65
800, 71
650, 58
1000, 90
1100, 95

This simple, tabular format is perfect. It explicitly tells ChatGPT what each column represents.

Step-by-Step Guide to Creating the XY Graph

Now that our data is ready, we can get ChatGPT (using the GPT-4 model with its Advanced Data Analysis capabilities) to create the graph. Behind the scenes, it will write and run Python code to generate a chart based on your instructions.

Graphed

Build AI Agents for Marketing

Build virtual employees that run your go to market. Connect your data sources, deploy autonomous agents, and grow your company.

Build Your First Agent

Step 1: Start a New Chat and State Your Goal Clearly

Begin your prompt by clearly telling ChatGPT what you want to do. Don’t be vague. A good initial prompt is a direct command.

Example Prompt:

I'm going to provide you with some data. I want you to create an XY graph (a scatter plot) based on it.

Step 2: Provide Your Well-Structured Data

In your next message, or within the same one, paste your prepared data. For our campaign performance example, it would look like this:

Here is the data:

Weekly Ad Spend ($), Leads Generated
300, 25
500, 42
450, 38
700, 65
800, 71
650, 58
1000, 90
1100, 95

Step 3: Specify the X and Y Axes

Even though we labeled our columns, it’s best practice to be explicit. Tell ChatGPT exactly which column should go on which axis to avoid any ambiguity.

Example Prompt:

Please create a scatter plot. The X-axis should be "Weekly Ad Spend ($)" and the Y-axis should be "Leads Generated".

ChatGPT will confirm your request and generate the graph. In a few seconds, it will display an image of your XY chart directly in the chat window, showing the points plotted according to your data. You’ll visually see how leads (Y) changed as ad spend (X) increased.

Step 4: Refine and Customize Your Graph

The first chart is rarely the final one. You’ll almost always want to tweak it. This is where the conversational nature of ChatGPT shines. You don’t need to click buttons in a complex menu, you just ask for what you want.

Here are some common refinement prompts:

Changing Titles and Labels

• "Add a title to the chart: 'Weekly Ad Spend vs. Leads Generated'."
• "Change the X-axis label to 'Dollars Spent per Week'."

Adjusting the Visuals

• "Can you make the dots blue and a little larger?"
• "Add a trendline to the plot to show the correlation."

Asking for Analysis

• "Based on this graph, does there appear to be a positive correlation?"
• "Which data point is the biggest outlier?"

Each time you ask for a change, ChatGPT will generate a new version of the chart for you. You can iterate this way until the graph perfectly communicates the insight you're looking for.

AI Agents for Marketing

Crash Course

Graphed

Free PDF · the crash course

AI Agents for Marketing Crash Course

Learn how to deploy AI marketing agents across your go-to-market — the best tools, prompts, and workflows to turn your data into autonomous execution without writing code.

Download the PDF

The Pros and Cons of Using ChatGPT for Charts

Making an XY graph in ChatGPT is fast and convenient, but it's important to understand where it excels and where it falls short compared to a dedicated business intelligence tool.

The Good Stuff

• Speed and Accessibility: You can go from raw data to a visualization in under a minute without buying or learning new software. If the data is simple, it’s incredibly efficient.
• No Technical Skills Required: You don’t need to know Python, Excel formulas, or BI software. You just describe what you need in plain English. This levels the playing field for non-technical team members.
• Conversational Refinement: The ability to tweak your chart through follow-up prompts is intuitive and powerful. It feels like collaborating with a data analyst.

The Limitations to Keep in Mind

• Static, Not Interactive: The chart ChatGPT creates is a static image file (like a PNG). You cannot hover over points to see data, filter results in real-time, or drill down into the insights.
• Data Security: You should be cautious about pasting sensitive business, customer, or financial analytics data into any third-party AI tool. Always check your company’s privacy and security policies first.
• Disconnected from Live Data: This is the biggest hurdle for business reporting. Your chart is a snapshot of the data at the moment you pasted it in. If your ad spend or lead numbers update tomorrow, your graph is instantly out of date. You’d have to repeat the entire process manually every single time.
• Gets Complicated Quickly: While great for a simple XY plot from a handful of data points, it can struggle with very large datasets or more complex demands. Analyzing data from multiple sources (e.g., ad spend from Facebook Ads and sales data from Shopify) is not its strong suit.

Final Thoughts

ChatGPT is a fantastic sketchbook for quick, on-the-fly data analysis. For visualizing a small dataset to spot a quick trend for a presentation or an internal conversation, it’s an amazingly fast and user-friendly tool that beats setting up a whole spreadsheet. Just prepare your data, ask clearly, and guide it to the final result you need.

However, when your goal moves from quick sketches to serious business reporting, the manual process of exporting data and creating static, disconnected charts becomes a productivity killer. We built Graphed to solve exactly this problem. By securely connecting directly to your live data sources like Google Analytics, Shopify, or HubSpot, we enable you to ask for a chart or dashboard in plain English, just like with ChatGPT, but the output is a live, interactive visualization that updates automatically. There's no more manually exporting CSVs - just a real-time view of your performance when you need it.