Is it possible to change the source range for a chart by manually changing a cell number

I often find I want to produce multiple identical charts running off source ranges which differ by just a column or so.
It is very tedious to go into 50 charts and to change the source range manually by typing $L$2:$L$51 over $B$2:$B$51 in every chart's source range for y-axis data and very time inefficient. Does anyone know if its possible to have the source range reference a cell in Excel, which would be much easier to update. E.g. by typing B in the cell instead of L would have the same effect as desired in my previous sentence.

( I am aware in the particular example above one could simply click on the chart and drag the highlighted cells to a different column which is very quick, but in some cases its more complicated than that. For example the source range cells are on a different worksheet, or are many columns apart.
Thanks

Yes_______________________

Any more to add Tim? thanks