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.

 

[kevin9999]

@rlv01 - I came to the same conclusion...

 

[rexcel3]

I must be missing something. Can you explain how you are sorting the range you posted? When I make a line chart using the Range("A3:B12") data you posted and sort the range using col A as the sort key, the line chart does not change when I sort col A ascending or descending.

View attachment 104344



The only time I can make it flip according to your image in post #1 is if I toggle the "Dates in Reverse Order" chart option.

see picture.

 

[rlv01]

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

 

[rexcel3]

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

View attachment 104497

strange.

Loading Google Sheets

docs.google.com

can u try to use my file?

 

[rlv01]

strange.

Loading Google Sheets

docs.google.com

can u try to use my file?

Not on this computer. I'll have to wait until later and try it on a different PC.

 

[rexcel3]

Not on this computer. I'll have to wait until later and try it on a different PC.

download it as excel file. i dont know why it opens in google sheet.
thanks.

 

[rlv01]

download it as excel file. i dont know why it opens in google sheet.
thanks.

I think you misunderstood. I'm saying that I cannot download random files off the internet from people I do not know on this PC.

 

[rexcel3]

I think you misunderstood. I'm saying that I cannot download random files off the internet from people I do not know on this PC.

i didnt misunderstand u bro. im waiting for your results.

 

[Alex Blakenburg]

I can see what you have done.
You have used the technique described below by BluePecanTraining to suppress the inbetween dates and only show your plotted dates by changing the Format >Axis Type to Text (instead of either Automatic or Dates). This seems to be the only option that resorts the labels when you resort the table.

Mynda from MyOnlineTraining has an work around for this but it is a bit of messing around:

 

[rlv01]

I can see what you have done.

Nice catch.