Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. I have a table that has life expectancy figures by year for both men and women.

Life expectancy table with columns for Year, Sex and (Years)

With so much data it is hard to visualize it so I ask Copilot:

Create a line chart of average life expectancy by year, with one line for men and another line for women

Copilot in Excel pane with the above prompt and the returned chart showing average life expectancy by year, with one line for men and another line for women.

I click on the add to a new sheet button in the Copilot pane and this chart gets inserted into my workbook:

chart showing average life expectancy by year, with one line for men and another line for women.

Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.

Thanks for reading,

Microsoft Excel Team

*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.

​Hi everyone, over the last few weeks we have had a series of posts to show you some of the things that are possible to do with Copilot in Excel. I have a table that has life expectancy figures by year for both men and women.
 
Life expectancy table with columns for Year, Sex and (Years)
 
With so much data it is hard to visualize it so I ask Copilot:
 
Create a line chart of average life expectancy by year, with one line for men and another line for women
 
Copilot in Excel pane with the above prompt and the returned chart showing average life expectancy by year, with one line for men and another line for women.
 
I click on the add to a new sheet button in the Copilot pane and this chart gets inserted into my workbook:
chart showing average life expectancy by year, with one line for men and another line for women.
 
Over the coming weeks I will continue to share more examples of what you can do with Copilot in Excel.
 
Thanks for reading,
Microsoft Excel Team
 
*Disclaimer: If you try these types of prompts and they do not work as expected, it is most likely due to our gradual feature rollout process. Please try again in a few weeks.  Read More

​