Hi,

I've been working on this issue for quiet some time now.I basically want the trailing 3 months from the month selected to be highlighted in a different color in the bar chart. For example - if I select Dec-16 then the months OCt-16,Nov-16 & Dec-16 should be highlighted in a different color compared to the other bars in the chart which remain the same.

Also Ive not been able to find a formula that would capture trailing 3 months based on month selected.

IT would be great if someone gave me any pointers on this.

Thanks,

Padhumai