Charts need to run by macros.

Hello Friends

Please refer the attached 2010 version file (charts need by macros.xlsx).

If we are inputting any date in `test chart' cell F2 (From 07/01/2005 to 11/30/2005) that month chart will be displayed in `Chart1'.

Now I need to take the values from `Inputs' cells B2 to B6 one by one and need to be pasted in `test chart' cell F2.

So that tottaly 5 different charts will be displayed one by one in `Chart1' and I will copy the charts one by one by using print screen and I will paste it in `output charts' as a image.

Unfortunately I have huge data I cannot make it manually, Is there any way to do this by using macros.

thanks in advance