I got it..

If any one wants to know how we can format x axis labels, please post your query

Thanks,

Hi

Normally when you have a date on 'On change of Field Value' / X axis and you want to display the date in either Mothname-Year / Day-Monthname then we will loose date sort order and it will sort on string value.

Unfortunately we don't have any option (formula editor) to change the sort or change the format of date in graph.

I followed to get desired results :

-Create a cross tab and place date field in columns.
-Go in Group Options-- Options tab-- go in Use a Formula as Group Name and give your formatted date (i.e formual which will display Day-Monthname)

-Place the sales / any data field in summarized fields.

Now insert a graph based on above cross tab.