Shortcut to change the column that is plotted in a chart

There are many trick to making things easier and depends on the case. If you have a chart you made for D vs B and you make it just the way you like and want to copy it but plot E vs B and then again for F vs B, etc... the easiest is to copy the whole chart then click on the series then just drag the highlighted box for the data source over 1 column. If that doesn't work then just edit the series equation in the formula box from $D$87:$D$95 to $E$87:$E$95 and in only a few clicks you have it. You can also click on the chart, go into the chart menu and click data source and then make changes there but I find that longer. You could also make a Macro to do it for you but unless it is a very specific repeated action you do over and over again I doubt the investment in writing the macro would pay off.