thanks sunny ,
but guage niddle is not moving when i select ,
1)Now i need to compare two months sales like current sales vs previous month sales could u please provide any qvd which related to my requirement..
i need to compare sales of last month and this month in diff guage chart side by side and LYTD and YTD ,last year this month and this year this month sales this is my requirement how to do this.
iam attaching my excel file .could any one help me.