I know I can create dynamic ranges but for me to do that I have to go and select each range and name it and put in set formula. That'll take just as much time as manually doing it in the short run.

My question is lets say I need to add two more columns for new months. Could I just make a change to one chart and it reflects that change in all the charts; like you can with tabs?

Or a vba that would let me update the range by two columns?

Thanks in advance!