Hi,
I am using a Line Chart in which I want my X-Axis to be shown in the “dd/mm” format, this data is coming from my Web-Service connection.The cells to which i have binded my Chart’s X-Axis has General format , as well as the Chart’s X-Axis format is kept as General.On the Dashboard it is seen properly, but when I take a snapshot some number formats in excel but not all change to Custom.I understand that since it is Date, excel’s number format automatically converts to Custom.My question is that then how come it is shown properly in Dashboard and why not all cells number format change to Custom.Do I need to change the number format in my Line Chart to show it in d/mm format.
I hope I have made myself clear.
Any help on this will be appreciated.
User0207 (BOB member since 2013-09-21)