Changing the date format from MM/DD/YYYY to DD/MM/YYYY


How can I change the date format on the x-axis of my graphs to DD/MM/YYYY? Currently, the format is MM/DD/YYYY. 

Second question, is it possible to reduce the tick values to DD/MM instead of DD/MM/YYYY? 

Kindly let me know. 



Nevermind, I worked it out.. 

double click the bottom axis - Ticks and Grids tab - Date format - Other- select format.