Excel Chart's DataTable shows wrong value

Please take a look at the below file.

https://www.dropbox.com/s/gjvd3vlipz...ssue.xlsx?dl=0

Chart's Data-Table is showing wrong values. The chart shows correct values.

Thanks.

Which are in the wrong order, the dates or the values?
What I mean is, should the dates be in descending order as per the table in P:R (in which case the numbers on the chart are the wrong way round), or should the dates be in ascending order (in which case the numbers are correct and the dates are wrong?)


Have a look at the attached. Is that what you need?

If so, all I did was change the axis format "Text Axis".


BSB

Hello BSB,

Your modification is perfect. This is how I wanted it to be.
But I am not able to do it on my own. I don't get any option to Format Axis when I right click there. Can you please tell how you did it?
I am using Excel 2010.


Thanks,
Tejas

If you left click on the X axis to select it, then right click on it, you should be given the format option.
See pic attached.

BSB

Thank you very much!!