• I have found the answer..There is an option of FORMAT CODE in the chart properties -> Data -> Values -> Point labels -> Format code..just enter the format there..

    e.g. for thousand separator use #,##0