Update the data in an existing chart Create a chart from a table Select the cells you want to use. Select Insert > Recommended Charts. Select the chart type you want, and select OK. Update a chart source With your table linked to a chart, make updates in your table and you'll see the changes reflected in the chart. Source: Microsoft