Named formulas are quite handy e.g. https://superuser.com/questions/464039/creating-a-chart-using-a-dynamic-named-range-in-excel-2010 https://superuser.com/ques

Named formulas are quite handy e.g. https://superuser.com/questions/464039/creating-a-chart-using-a-dynamic-named-range-in-excel-2010 https://superuser.com/questions/464039/creating-a-chart-usin...