Monty
Well-Known Member
Hello Team.
iam not really sure if this can be done with the help of excel formula or vba..
i wanted to have in chart always 12months
i wanted to select current month (Example Feb15 ) from the drop down and wanted to the chart data should move from current month to next 12 months ( Ie. Feb 15 to jan16).
Please find attached example excel file.
Post moved by mod.
.
iam not really sure if this can be done with the help of excel formula or vba..
i wanted to have in chart always 12months
i wanted to select current month (Example Feb15 ) from the drop down and wanted to the chart data should move from current month to next 12 months ( Ie. Feb 15 to jan16).
Please find attached example excel file.
Post moved by mod.
.
Last edited by a moderator: