Copilot
Copilot in Excel
Copilot in Excel
Create charts with Copilot in Excel
Applies To
Excel for Microsoft 365

Warning: This feature is being deprecated. App Skills will be removed from Excel by late-February 2026. You can use Agent Mode in Excel to create charts edit your workbook, Copilot Chat to ask basic questions, or explore with Analyst for deep reasoning data analysis.

If you have data that you want to view as a chart, Copilot in Excel can create one for you. 

Note: Copilot in Excel currently supports over twelve types of charts, but it does not generate every chart type available in Excel.

  1. Open Excel.

  2. From the Home tab, select the Copilot small image of the Copilot icon. button.

  3. Make sure to format your data in a table or supported range.

  4. Ask Copilot to create the kind of chart you want. You can copy and paste one of the example prompts, or type something in your own words.

  5. Copilot generates a chart.

  6. Select +Add to a new sheet​​​​​​​ to add the generated chart into your workbook.

Try creating charts with prompts like:

Icon depicting a document with sparkles Create a chart from this table that has vendor budget on the X axis and headcount on the Y axis. 

Icon depicting a document with sparkles Use 10,000 as the baseline. Create a line chart showing change over time. Show data labels and gridlines. 

Icon depicting a document with sparkles Show a chart comparing Position in Range to diversity statistics such as generation, ethnicity, and gender. 

More ways to work with Copilot in Excel

Welcome to Copilot in Excel

Identify insights with Copilot in Excel

Create a chart from start to finish

Facebook LinkedIn Email

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center