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

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