Copilot in Excel will summarize text columns and create custom and PivotTable charts

The new updates will be released in July.

Reading time icon 2 min. read

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team Read more

copilot in excel

Great news for those using Copilot in Excel. Microsoft will update the AI model to support column text summarization and the ability to create custom charts and PivotTable. According to the latest entries in the Microsoft 365 Roadmap, these updates will be rolling out gradually to users starting next month, in July.

You can now ask for more specific charts and PivotTables, including specifying the x and y axis of charts.


Copilot can analyze columns of text to give you summaries of the information. For example, Copilot will find the main themes in survey responses from open-ended questions.


Copilot in Excel is already capable of summarizing, but not at this level; the AI model can also extract data from different sheets so that you can create reports or plans more easily and quickly, but the Redmond-based tech giant is taking it to the next level.

PivotTables in Excel are used to calculate, summarize, and analyze data, letting you see comparisons, patterns, and trends in your data. Copilot’s ability to analyze your sheets and create such tables could greatly streamline workflows and allow you to have the information at hand when needed in a short amount of time.

Microsoft says in the description that Copilot will consider details about these charts, including the x and y axes, so users won’t have to worry about incomplete information.

More about the topics: Copilot, microsoft