macros to run graphs

Hi,

I'm quite inexperienced with macros so was hoping i could get some help.

I need to set up a macros that will automatically run graphs for me. The reason i want to do it with a macros is because the number of dates will always change so i'd have to go into each graph and manually change the range it's looking at. Is this possible? I've attached a spreadsheet with what i want the final outcome to look like. The graphs will pull from the 'Workings' tab.

Thanks,
John