You have a spreadsheet full of numbers and you need a chart to show the trend or distribution. Manually selecting the right chart type and configuring axes takes time and often requires trial and error. Copilot in Excel can read your data and suggest the most appropriate chart based on the columns and rows you select. This article explains how to use Copilot suggestions to convert raw Excel data into a chart in a few clicks.
Copilot analyzes your data structure, detects numeric and categorical columns, and proposes chart types such as bar, column, line, pie, or scatter. You do not need to know charting rules or advanced Excel features. Copilot handles the formatting, axis labels, and legend placement automatically. The result is a chart that updates when your source data changes, keeping your reports current.
Key Takeaways: Using Copilot to Create Charts in Excel
- Copilot pane > Chart suggestions: Copilot scans your selected data and recommends bar, line, column, pie, and scatter charts.
- Data selection before prompting: Always highlight the cell range that contains the data you want to chart. Copilot uses the active selection to generate suggestions.
- Refine with natural language: After Copilot inserts a chart, you can type follow-up requests like “show data labels” or “change to line chart” to adjust the output.
What Copilot Chart Suggestions Do in Excel
Copilot chart suggestions are a feature in Microsoft 365 Excel that uses the large language model behind Copilot to understand your spreadsheet data and recommend visualizations. When you select a range of cells and open the Copilot pane, Copilot reads the column headers and row values. It identifies which columns contain numbers that could be plotted on a y-axis and which columns contain labels that could appear on an x-axis or as legend entries.
The feature does not replace Excel’s existing chart tools. Instead, it accelerates the decision-making process. Instead of opening the Insert Chart dialog and guessing which chart type fits your data, you see a short list of suggestions. Each suggestion comes with a preview of how the chart will look based on your actual data. You can accept one suggestion or ask Copilot for a different chart type.
Prerequisites for using Copilot chart suggestions:
- A Microsoft 365 subscription that includes Copilot for Microsoft 365. Copilot is not available in the free web version of Excel.
- Excel version 2402 or later for Windows. Mac and web versions support Copilot chart suggestions beginning in April 2024.
- Data organized in a table or a contiguous range. Copilot works best when the first row contains column headers and there are no blank rows or columns in the selection.
Steps to Create a Chart from Excel Data Using Copilot
Follow these steps to convert your spreadsheet data into a chart using Copilot suggestions. The steps assume you have a Microsoft 365 subscription with Copilot enabled and your data is in a clean table format.
- Open Excel and select your data range
Click and drag to highlight the cells that contain the data you want to visualize. Include the column headers in your selection. Do not select empty rows or columns. For best results, ensure the data is in a flat table, meaning one header row and no merged cells. - Open the Copilot pane
On the Ribbon, click the Copilot button in the Home tab. The Copilot pane opens on the right side of the Excel window. If you do not see the Copilot button, confirm that your Microsoft 365 account has Copilot enabled and that you are signed in with your work or school account. - Ask Copilot to suggest a chart
In the Copilot text box at the bottom of the pane, type a prompt such as “Suggest a chart for this data” or “What chart type works best for these numbers?” Press Enter. Copilot scans the selected range and displays a list of chart suggestions. Each suggestion includes the chart type and a brief description, such as “Column chart showing monthly sales by region.” - Select a chart suggestion
Click the chart suggestion you want to use. Copilot inserts the chart as a floating object on the current worksheet. The chart is linked to your selected data range. If you update the data, the chart updates automatically. - Refine the chart with follow-up prompts
After the chart appears, you can type additional requests in the Copilot pane to modify the chart. For example, type “Add data labels” or “Change the chart title to Quarterly Revenue.” Copilot applies the change without requiring you to use the Chart Design or Format tabs. You can also type “Try a line chart instead” to replace the current chart with a different type.
If Copilot Does Not Suggest the Right Chart
Copilot chart suggestions work best with structured data. If the suggestions do not match what you expect, check the following conditions before trying again.
Copilot shows no chart suggestions
This happens when the selected range contains only text, only numbers, or has blank rows or columns. Copilot needs at least one column of labels and one column of numeric values to generate a chart. Select a range that includes both a categorical column, such as months or product names, and a numeric column, such as sales or quantity. Remove any blank rows within the selection and ensure there are no merged cells.
Copilot suggests a chart type that does not fit the data
If Copilot suggests a pie chart when you need a bar chart, you can override the suggestion. After the chart is inserted, type “Change to a bar chart” in the Copilot pane. Copilot replaces the chart with the requested type. You can also type “Show me a scatter plot” or “Use a stacked column chart” to get the exact visualization you want.
The chart does not include all the rows or columns
Copilot bases the chart on the selected range at the time you submitted the prompt. If you add new data to the spreadsheet after the chart is created, the chart does not automatically expand. To include new data, select the updated range and ask Copilot again. Alternatively, convert your data range to an Excel table using Ctrl+T before creating the chart. Charts based on Excel tables automatically include new rows added to the table.
Copilot Chart Suggestions vs Manual Chart Insertion
| Item | Copilot Chart Suggestions | Manual Chart Insertion |
|---|---|---|
| Time to create a basic chart | 10-20 seconds with one prompt | 30-60 seconds depending on chart type selection |
| Chart type selection | Copilot analyzes data and proposes types | User must know which chart type fits the data |
| Customization after creation | Natural language prompts like “add data labels” | Ribbon tabs, Format pane, right-click menus |
| Data range update handling | Manual re-selection needed unless data is an Excel table | Same behavior as Copilot |
| Learning curve | Low — requires only typing a sentence | Medium — requires knowledge of chart elements and formatting |
Use Copilot suggestions when you want a quick, correctly typed chart without opening multiple dialog boxes. Use manual insertion when you need fine-grained control over every element, such as custom error bars or complex combo charts that Copilot does not support.
You can now convert any structured Excel data into a chart using Copilot suggestions in under 30 seconds. Start by selecting your data range and typing “Suggest a chart for this data” in the Copilot pane. After the chart appears, use follow-up prompts like “format the legend to the bottom” or “change colors to blue” to polish the output without touching the Ribbon. For recurring reports, convert your data to an Excel table first so that new rows are automatically included in future chart updates.