Question

after a chart has been inserted and formatted is it possible to change the data value on which the chart is prepared or to add new rows of data

Answer 1

Yes, you only need to refresh the values from the data toolbar. click on the chart and choose Option refresh values. it will automatically take updated values