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