MPG Compitition

[Ben Jay]

right the only issue im having is how to format the chart so it updates automatically when you add new data.
any one have any ideas?
At the moment you update the chart by adding the next number in the range

For example the x and y values go to row 30, so the next value will be in row 31. so you can go to the chart and just add the next number in each source.