Applies ToExcel for Microsoft 365 Word for Microsoft 365 PowerPoint for Microsoft 365 Excel for Microsoft 365 for Mac Word for Microsoft 365 for Mac PowerPoint for Microsoft 365 for Mac Excel 2024 Word 2024 PowerPoint 2024 Excel 2024 for Mac Word 2024 for Mac PowerPoint 2024 for Mac Excel 2021 Word 2021 PowerPoint 2021 Excel 2021 for Mac Word 2021 for Mac PowerPoint 2021 for Mac Excel 2019 Word 2019 PowerPoint 2019 Word 2019 for Mac PowerPoint 2019 for Mac Excel 2016 Word 2016 PowerPoint 2016 PerformancePoint Dashboard Designer

If you need to change data in a chart, you can do it from its source.

Your browser does not support video. Install Microsoft Silverlight, Adobe Flash Player, or Internet Explorer 9.

Try it!

Changes you make will instantly show up in the chart. Right-click the item you want to change and input the data--or type a new heading--and press Enter to display it in the chart. 

To hide a category in the chart, right-click the chart and choose Select Data.  Deselect the item in the list and select OK.

To display a hidden item on the chart, right-click and Select Data and reselect it in the list, then choose OK.

See Also

Create a chart from start to finish

Get Microsoft chart templates

Need more help?

Want more options?

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