How to Make a Chart in Excel with AI

Creating charts in Excel used to be a hands-on, multi-click process. Now, with built-in AI, you can generate insightful visualizations just by asking questions in plain English. This article will show you exactly how to use Excel's AI features to create charts instantly, transforming how you work with data.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Why Use AI to Make Charts in Excel?

For years, making an Excel chart followed a familiar script: highlight your data, click the "Insert" tab, guess the right chart type, and then spend another ten minutes formatting colors, labels, and titles. It worked, but it was often tedious and assumed you already knew what you were looking for.

AI flips that process on its head. Instead of being a manual tool, Excel can now act as your own data analyst. The primary benefit is speed. What once took several minutes of clicking and adjusting can now be accomplished in seconds. You describe what you want to see, and Excel builds it for you.

This also dramatically lowers the skill barrier. You no longer need to be a master of PivotTables or VLOOKUPs to uncover relationships in your data. The AI can sift through your rows and columns, identify meaningful patterns, and suggest charts that highlight those insights automatically. This frees you from the mechanical "how" of building the chart so you can focus on the "why" behind the data.

Think of it as the difference between building a car engine piece by piece versus just telling your smart car where you want to go. Both get you to a destination, but one lets you focus on the journey and the destination, not the complicated mechanics under the hood.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Understanding Excel’s Built-in AI Tools

When we talk about "AI in Excel," we're mainly referring to two core features:

• Analyze Data (formerly Ideas): This is the most readily available AI tool, accessible to most Microsoft 365 subscribers. It lives on the "Home" tab and acts as an automated analysis engine. It reviews your selected data set and recommends PivotCharts, tables, and statistics it thinks you'll find interesting. It also includes an input box for asking specific questions in natural language.
• Microsoft Copilot: This is the newer, more powerful AI assistant powered by large language models similar to ChatGPT. Copilot is a premium add-on that brings a conversational chat interface directly into Excel. It can understand more complex commands, generate formulas, create entire dashboards, and offer detailed summary insights. While not everyone has access yet, it represents the future of data interaction in spreadsheets.

For this tutorial, we will focus primarily on the Analyze Data feature, as it's the tool that millions of Excel users can access and benefit from today.

Step-by-Step Guide: Making AI Charts with "Analyze Data"

Let's walk through creating a chart with AI using a simple dataset. Imagine you have a table tracking monthly sales of different products.

Month, Product Category, Units Sold, Revenue January, Electronics, 150, $75,000 January, Clothing, 400, $20,000 February, Electronics, 175, $87,500 February, Clothing, 450, $22,500 March, Electronics, 200, $100,000 March, Clothing, 500, $25,000 ...and so on.

Step 1: Your Data Needs to Be Clean and Structured

AI is smart, but it's not a mind reader. It works best with clean, well-organized data. Before you start, make sure your data follows these best practices:

• Use a simple tabular format. Each column should have a clear header (like "Month," "Revenue," "Product Category"), and each row should represent a single record.
• Avoid blank rows or columns. Don't leave empty rows in the middle of your dataset, as Excel might think that's where your data ends.
• Remove merged cells. Merged cells above headers or within the data can confuse the AI. Unmerge everything for the best results.

A quick pro-tip is to select your data and press Ctrl+T (or Cmd+T on Mac) to format it as an official Excel Table. This not only makes it look better but also explicitly defines the data range for Excel's features, making the AI's job much easier.

Step 2: Select Your Data and Launch "Analyze Data"

Simply click on any single cell inside your data table. You don't need to highlight the entire thing, especially if you've already formatted it as an Excel Table. Then, navigate to the Home tab on the Ribbon and click the Analyze Data button on the far right.

Graphed

Your AI Data Analyst to Create Live Dashboards

Connect your data sources and let AI build beautiful, real-time dashboards for you in seconds.

Build Your First Dashboard

Step 3: Review the AI-Suggested Charts

A new "Analyze Data" pane will slide out from the right side of your screen. Excel has already "read" your data and is now suggesting visualizations and insights it has discovered. It might show things like:

• A bar chart showing revenue by product category.
• A line chart showing the trend of units sold over time.
• A PivotTable summarizing total revenue for each month.

Scroll through these suggestions. If you see one you like, simply click the + Insert PivotChart button below it, and Excel will instantly add it to a new sheet in your workbook.

Step 4: Create a Custom Chart by Asking a Question

The real power of Excel's AI comes into play with the natural language query box at the top of the "Analyze Data" pane. Here, you can move beyond the pre-made suggestions and ask for exactly what you want.

Let’s try it with our example data. Click into the box that says "Ask a question about your data..." and type:

“total revenue by month as a line chart”

Press Enter. Instantly, Excel interprets your request, generates the corresponding PivotChart, and displays a preview in the pane. If it looks correct, click + Insert PivotChart to add it to your workbook.

You can ask much more complex questions, too. Try some of these:

• “which product category had the highest units sold in March?”
• “compare revenue for electronics vs clothing”
• “% of total revenue by product category”

The AI handles the filtering, grouping, and calculations behind the scenes. It creates the necessary PivotTable and builds the chart off of it, saving you all the manual steps.

AI for Data Analysis

Crash Course

Graphed

Free PDF Guide

AI for Data Analysis Crash Course

Learn how to get AI to do data analysis for you — the best tools, prompts, and workflows to go from raw data to insights without writing a single line of code.

Download Free Guide

Advanced Charting with Microsoft Copilot

If you have access to Microsoft Copilot for Microsoft 365, you can take natural language charting to another level. Copilot is a conversational partner that can handle multi-step commands and context.

For example, with Copilot you could ask:

1. “Show me a breakdown of revenue by product category.”
2. Once the chart appears, you could follow up with: “Now create another chart showing the trend of just the Electronics category over time.”
3. And then: “Combine both of these onto a new dashboard sheet and add a title.”

Copilot maintains the context of your conversation, allowing you to build and refine visualizations interactively. It can also do more than just create charts - it can highlight insights, predict trends, and even suggest next steps for your analysis directly in the chat pane. While newer, it showcases a powerful shift toward fully conversational data analysis within your spreadsheet.

Tips For Getting the Best AI-Generated Charts

To get the most accurate and useful results from Excel’s AI features, keep these pointers in mind:

• Garbage In, Garbage Out: The number one rule is that your data quality determines your output quality. Take a few minutes to clean up your data - make sure dates are formatted as dates, numbers as numbers, and text is consistent. "Clothing" and "clothes" will be treated as two different categories.
• Don't Be Vague: The more specific your question, the better the result. Instead of "show sales," try "show total revenue by salesperson as a column chart." Mentioning the chart type you want (bar, line, pie, etc.) helps the AI deliver exactly what you've envisioned.
• Use Excel Tables (Ctrl+T): This is worth repeating. Formatting your data as a table is the easiest way to ensure Excel knows precisely where your dataset begins and ends. It also automatically updates the range if you add new rows of data.
• Check the Results: AI is fantastic, but it's not foolproof. Always give the resulting chart a quick sanity check to ensure it's accurately reflecting your data and answering the question you intended to ask. Sometimes it might misinterpret a header or a data type, so a quick visual scan is always a good idea.

Final Thoughts

Using AI in Excel reshapes chart creation from a manual chore into a quick and intuitive conversation. By leveraging features like "Analyze Data," anyone can uncover trends and create professional-looking visualizations in seconds, regardless of their technical spreadsheet skills. It's a powerful way to get straight to the insights without getting stuck on the mechanics.

As you get more comfortable analyzing data from a single spreadsheet, you might find yourself needing to connect data from different platforms - like Google Analytics, Salesforce, or your ad platforms. Before you start downloading and combining CSV files, that's where we've built Graphed to help. We allow you to connect all your data sources in one place and use natural language to build real-time dashboards instantly, making cross-platform analysis as simple as asking a question.