M365 Excel - Update the data in an existing chart

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

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.