Need help using columns series or sequence

I'm trying to write a macro that will update charts.

Basically in the example picture linked below, columns A-C are plotted in the two charts. (The real workbook has a lot more data.) I want to develop a macro that will update to charting columns B-D, then C-E, etc; shift the range by 1 column to the right every time I run it. I hope to alleviate the need to manually click on each chart and select the new source data. This seems like it would be pretty simple but I can't figure out the syntax in vba. I don't have a lot of experience coding in vba; I usually use the macro recorder and then edit parts of the code as necessary.

Thanks for any help, sorry if this has been addressed before or covered recently.

http://i67.photobucket.com/albums/h294/t3355/excel.jpg