Graph/chart axis max reference

Is it possible to set a reference cell for a graph's axis max?

Basically I have a set of data in 2 columns that updates every week and the date on the graph need to be update. Thanks