Hi Sir,
Awesome , you saved me.
I was doing in a different way like I was making every column dynamic which I needed to show in chart and making separate dynamic chart like months, HC, AHC, CLOSING HC, and making separte columns for every department and repeating them, like months, HC, CHC, AHC ,was doing lot of work. and making separate chart for them and made around 18 charts. I read interactive dynamic chart. I was thinking to that. but right now I am doing the way you did . easy to do .
But you gave me second thought where I was unable to work.
I have some query like for Data_Set I want to make it dynamic because later i want to add some more columns. So How can I make their heading dynamic.
Why in the scattered plot months was missing in between? How can we show every months?
Second issue I was facing while doing comparison in 2nd chart when I was changing the chart areas then I was facing months problem . like Aprl'13 to Dec'13 and Jan'14 to Dec'14. so in column chart months was changed taking data from arpil 13 ' to dec'13 for both the series not in the scattered plots.
and what is this =Months14-365 in months14_offset.
Ashish - I also like your suggestion because i have to show different trends individual and comparison of different years which can come out from a data. If you have any ideas please share with me.