How do I make a chart that remembers its last data point & plots new as new data is entered?

[Matrix67]

I am a quality control inspector & have a spreadsheet that I update 2 to 3 times a day, this constantly changes the performance ratio of each branch, 6 in total, the problem I have is creating a chart that saves each entry & plots a new entry every time data is entered to show if the performance of each branch is improving or not....any advise? Thanks Marco

 

[SydneyGeek]

Here's a tutorial that shows how to build a dynamic chart.

Denis

 

[AlphaFrog]

You want to create a dynamic range chart. Here are some step-by-step guides

Using named ranges to create dynamic charts in Excel

http://www.youtube.com/watch?v=7le-m8YRP6M

Dynamic Charting Formulas in Excel