Copilot in Excel Cannot Create Chart From Prompt: Fix

You type a natural language prompt like “Create a column chart of sales by region” but Copilot in Excel responds with an error or does nothing. This failure usually occurs because Copilot cannot map your prompt to the correct data range or because a required setting is blocking chart generation. This article explains the root cause of the problem and provides step-by-step fixes to get chart creation working again.

Copilot in Excel generates charts by interpreting your prompt and applying a built-in chart template to the selected or detected data range. When the prompt lacks specific column names or the data contains merged cells, empty rows, or unsupported formats, Copilot stops before creating the chart. You will learn how to prepare your data, adjust Copilot settings, and use alternative methods to force chart creation.

Why Copilot in Excel Fails to Create Charts From Prompts

Copilot in Excel relies on the Microsoft Graph data connection to read your worksheet content. When you type a prompt, Copilot sends the request to the cloud, which analyzes the data structure and matches your words to column headers and cell values. If the data is not formatted as a table, contains merged cells, or has blank rows, the cloud service cannot interpret the structure and returns a failure message.

Another common cause is a missing or inactive Copilot license. Copilot chart creation requires Copilot for Microsoft 365, not the free Copilot with Bing Chat. The free version cannot access Excel data at all. Additionally, the Excel workbook must be saved in OneDrive or SharePoint Online; local-only files are not accessible to the cloud service.

Data Format Requirements for Chart Prompts

Copilot expects data in one of these formats:

• An Excel table with headers in the first row and no empty rows or columns inside the range.
• A named range that covers the complete data set including headers.
• A contiguous range with no merged cells, subtotals, or outlines.

If your data uses merged header cells or contains blank rows between sections, Copilot will reject the prompt. The fix is to unmerge cells and fill in missing data before running the prompt again.

Steps to Fix Copilot Chart Creation in Excel

Follow these steps in order. Test chart creation after each step to see if the fix resolves the issue.

1. Verify Your Copilot License
   Open any Microsoft 365 app and go to File > Account. Under Subscription, confirm you see “Copilot for Microsoft 365” or “Microsoft 365 E5 with Copilot.” If you see only “Microsoft 365 Business Basic” or “Microsoft 365 Apps for business,” you do not have the correct license. Contact your admin to assign a Copilot license.
2. Save the Workbook to OneDrive or SharePoint
   Copilot requires cloud access to your file. Click File > Save As and choose OneDrive or SharePoint. If the file is stored on a local drive, Copilot cannot read it. After saving, close and reopen the workbook.
3. Convert Data to an Excel Table
   Select any cell inside your data range. Press Ctrl+T. In the Create Table dialog, ensure “My table has headers” is checked. Click OK. This gives Copilot a structured schema it can query.
4. Remove Merged Cells and Blank Rows
   Select the entire data range. On the Home tab, click Merge & Center > Unmerge Cells. Then select all cells, press F5, click Special, choose Blanks, and click OK. Right-click any selected blank cell and choose Delete > Entire row. Repeat until no blank rows remain within the data.
5. Enable Copilot Data Sources in Settings
   Open the Copilot pane by clicking the Copilot icon on the Home tab. Click the Settings gear icon in the top-right corner of the pane. Under Data sources, make sure “Microsoft Graph” is toggled on. Close the settings panel.
6. Type a Precise Chart Prompt
   Click inside the Excel table. In the Copilot pane, type a prompt that includes the chart type and the column names. Example: “Create a clustered column chart with Region on the X-axis and Sales on the Y-axis.” Press Enter. Copilot should generate the chart within 10 seconds.
7. Use the Copilot Suggested Charts Option
   If the prompt still fails, click the Copilot icon on the Home tab and select the “Analyze” option. Copilot will show suggested charts. Click any suggestion to insert the chart directly. This bypasses the prompt interpretation step.

If Copilot Still Has Issues After the Main Fix

Copilot Returns “I can’t create that chart” or “I don’t have enough information”

This error means Copilot cannot match your prompt to the data. Check that your column headers exactly match the words in your prompt. For example, if your header says “Sales_Amount” but you type “Sales,” Copilot will not find the column. Rename headers to simple single words like “Sales” or “Revenue.” Also ensure the data range contains at least two columns and five rows of numeric data.

Copilot Creates a Chart but With Wrong Data

When Copilot picks the wrong columns, your prompt likely did not specify column names. Always include the exact column names from your table header row. If the chart still uses the wrong columns, delete the chart and use the Copilot suggested charts method instead.

Copilot Pane Shows “Getting ready” Indefinitely

This is usually a network or service issue. Close Excel completely. Restart your computer. Open Excel and the workbook again. If the problem persists, go to the Microsoft 365 admin center and check the Service Health dashboard for any Copilot outages. Wait until the service is restored before retrying.

Copilot Chart Prompt vs Manual Chart Insertion: Key Differences

Item	Copilot Chart Prompt	Manual Chart Insertion
Data format required	Excel table with headers, no merged cells	Any contiguous range, merged cells allowed
Chart type selection	Determined by your prompt words	You choose from the Insert > Charts gallery
Cloud dependency	Requires OneDrive/SharePoint and Microsoft Graph	Works with local files
Error messages	Generic “I can’t do that” without details	Excel shows specific error codes
Speed	5-10 seconds processing time	Instant insertion

When Copilot fails repeatedly, manual chart insertion is the reliable fallback. Use the Insert > Charts menu and select the chart type you need. You can then apply formatting and labels manually. This method bypasses all Copilot restrictions.

After applying the steps above, you should be able to create charts from Copilot prompts in Excel. Test with a simple prompt first: “Create a bar chart of Product by Quantity.” If that works, move to more complex prompts with multiple series. For advanced users, consider creating a named range before prompting Copilot; this gives Copilot an explicit data reference and reduces interpretation errors.