The problem is, it it's modifying my range selection. In the chart I select ranges Sheet2!A:A, Sheet2!B:B, but after clicking ok, and going back into the chart, it modified my range selection to Sheet2!A1:A161, Sheet2!B1:B161 which includes all of the rows currently in the document, but if I add another row, it is not added to the chart. Is there a way to have new rows automatically added to the chart?
How to have charts include added rows in google docs
google spreadsheets;google documents