Applies ToExcel for Microsoft 365

Tell Copilot what kind of chart you want, and it will try to create it for you.

Create a line chart for the last year of revenue

The Copilot pane showing a prompt of "Create a line chart showing revenue over the last year" followed by a generated line chart showing revenue. 

Copilot can't create every kind of chart that Excel supports yet, but it does support more than a dozen different kinds of charts now with more on the way. 

Take your prompts to the next level

The more details you give it about what you want, the better the results you'll get.

Create a chart from this table that has vendor budget on the x axis and headcount on the y axis.

You can also specify details about the chart configuration. For example:

Use 10,000 as the baseline, create a line chart showing change over time. Show data labels and gridlines.

Another option is to tell Copilot what your goal is and let it create the chart.

​​​​​​​Show a chart comparing Position in Range to diversity statistics such as generation, ethnicity, and gender.

Learn more

Welcome to Copilot in Excel

Identify insights with Copilot in Excel

Create a chart from start to finish

Need more help?

Want more options?

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

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.