If you plot data in a table and subsequently add new rows or columns to the table, Excel automatically incorporates those rows or columns into the chart.

If you want your chart to focus on particular rows of data within a large block, a table can make that process more convenient. When you convert a range to a table, Excel adds filter controls to each column in the range. You can use these controls to hide the rows in which you’re not currently interested. So, for example, you can set up a chart that plots the most recent month’s numbers in a table of time-related data or the rows that have the top 10 values in some column of interest. Note, however, that when you change or remove the filter, Excel adjusts the chart so that it plots the visible rows. To make a permanent plot of particular rows in a range, select those rows explicitly without filtering the range. (You can plot noncontiguous rows by holding down Ctrl while you select each one.)

If you want your source data and chart to have consistent or complementary formatting characteristics, you can achieve that more easily using table styles and chart styles.