If I understood correctly from the project's description, you have numerical data into one sheet and you want to show them on a linear graph? Of course, each time data change in your tables, this should be reflected on the graph.
Is that correct or not?