What's New in Excel (February 2024)

Welcome to the February 2024 update.

This month, we are excited to share that the Chart data task pane and the ability to use images and data types in your PivotTables are now available in Excel for the web. The new default theme for Office is generally available in Excel for Windows and Mac now as well. 

Excel for Web:

1. Chart Data Task Pane 
2. Images and Data Types in PivotTables

Excel for Windows:

1. New Default Theme for Office

Excel for Mac:

1. New Default Theme for Office

 

Excel for Web

1. Chart Data Task Pane

You can now use the data task pane to edit your chart's data on the web. The data task pane supports the following:

• Change a chart's source data range via range picker UI (mouse selection)
• Expose new web-first UI to determine how data series are displayed on the chart (including which axis they are displayed on)
• Provide controls for configuring how hidden/empty cells appear and whether the source data is split by rows or columns

*This capability is already supported for Mac and Windows users

 

Chart Data Task Pane

 

2. Images and Data Types in PivotTables
Create richer and more visually appealing PivotTables that include images and other Excel data types like Stocks and Geography. While data types and in-cell images are a powerful part of modern Excel, PivotTables could only show a text description of these modern content types. Now, images and data types come intact to your PivotTable rows and columns. This feature has now been released to all Excel web users. Read more here >
Use Images and Data Types in your PivotTables

Excel for Windows

1. New Default Theme for Office
We’ve refreshed the Office theme with a new default font, color palette, style, and line weights that help you make your documents more modern and accessible. This feature was previously released to Insiders users and is now generally available to all Windows and Mac users. Read more here >

 

Excel for Mac

1. New Default Theme for Office

We’ve refreshed the Office theme with a new default font, color palette, style, and line weights that help you make your documents more modern and accessible. This feature was previously released to Insiders users and is now generally available to all Windows and Mac users. Read more here >

 

 

Check if a specific feature is in your version of Excel Click here to open in a new browser tab

 

Your feedback helps shape the future of Excel. Please let us know how you like a particular feature and what we can improve upon—"Give a compliment" or "Make a suggestion"..  You can also submit new ideas or vote for other ideas via Microsoft Feedback.

 

Subscribe to our Excel Blog and the Insiders Blog to get the latest updates. Stay connected with us and other Excel fans around the world – join our Excel Community and follow us on X, formerly Twitter.

 

Special thanks to our Excel MVPs David Benaim and Bill Jelen for their contribution to this month's What's New in Excel article. David publishes weekly YouTube videos and regular LinkedIn posts about the latest innovations in Excel and more. Bill is the founder and host of MrExcel.com and the author of several books about Excel.