You can change the source data in a chart at any time by entering the new values in the respective cells. The chart will update automatically when you enter new information.
The following actions with the source data will also result in updating a chart:
•Hiding or unhiding rows or columns
•Inserting or deleting rows or columns
•Range sorting or filtering
•Merging or splitting cells
•Changing the cell format