Using a "Pie Chart" ( I know, boo) with two values. These values are updated
weekly - on same worksheet, next row, same column.

How do I have the chart updated weekly to the current values, other than
reassigning the "source data" link manually?