Thanks for your input.
This is not exactly I am looking for.
What I want is :
My chart will only show two columns
1. The latest month sales data ( Jan 12 as shown above)
2. Percentage change of Jan 12 with Dec 11 ( But Dec 11 data will not appear in the chart)
And I want to make this dynamic ( To make it dynamic I have defined 6 variables for 6 months)
Jan 12 - Var1
Dec11 - Var2
Nov11 - Var3
Oct11 - Var4
Sept11 - Var5
Aug11 - Var6
Var1 will show the latest month end date within the date range
Var2 will show month prior to Var1
..... and so forth..