Adding icons to visualize results with Copilot in Excel

Greetings, We’re continuing our series of posts to show you some of the things that are possible to do with Copilot in Excel. Today I will show you how Copilot can help add icons to better visualize results. I will start with some result data:

 

Table including 3 columns, including ID, Results (#), and Results (%)

 

To add the icons I will ask Copilot: Add an icon set to both results columns

 

Copilot in Excel pane showing the above prompt and a response for a conditional formatting rule to review and apply, with a button to apply the conditional formatting.

 

OK! Looking at B2:D23, here are 2 conditional formatting rules to review and apply:

• Icon Set: Apply an icon set rule on C3:C23
  • 3 Arrows
• Icon Set: Apply an icon set rule on D3:D23
  • 3 Arrows

I click on the apply button and get the following result:

 

Results table with Green, Yellow and Red arrows indicating the magnitude of the values in the results columns.

 

Over the coming weeks I will be sharing 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.