Learn how to make the chart series data dynamic, thus when you add or remove rows the chart gets automatically updated. You can use excel tables or OFFSET formula to do this. Use this tutorial (and downloadable example) know how to do this using Microsoft Excel.
