how can i sort table without line-chart getting reversed?

[rexcel3]

how can i sort table by newest or oldest without the chart reversing?

dates r formatted as date.
amounts r formatted as number.

 

[rexcel3]

I cannot reproduce your problem. The behavior I see when I use your data is not as you have described.

View attachment 104497

i see now, your dates in x-axis r not same as in table.
but the problem is solved. thank u.

 

[Alex Blakenburg]

Thanks for letting us know. Glad @rlv01 and I were able to help.