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.

 

[rlv01]

Have 2 tables. One for plotting, one for sorting.

 

[rexcel3]

Have 2 tables. One for plotting, one for sorting.

so when i need to create new rows to my table, do i need to do that twice to two tables?

 

[rlv01]

Maybe. Or maybe you would set up automation to populate the sort table (or vice-versa). That's what I would do. Because if there is a way to sort your plot table without changing the plot, I don't know of it.

 

[rexcel3]

Maybe. Or maybe you would set up automation to populate the sort table (or vice-versa). That's what I would do. Because if there is a way to sort your plot table without changing the plot, I don't know of it.

i dont understand.
could u show how this is done?

 

[rlv01]

could u show how this is done?

Please use XL2BB to post data from a sample table that I can work with.

 

[Alex Blakenburg]

If it is a permanent difference ie you are showing both the table and chart in your report and you want one ascending and one descending then you can tell the Chart Axis to show in reverse order.
• Select the Horizontal Lables in the chart.
• Right click > Format Axis (or Ctrl+1)
• Check the box on the last item under Axis Options "Dates in reverse order"

 

[rexcel3]

Please use XL2BB to post data from a sample table that I can work with.

View attachment 104259

is this correct?

transaktioner.xlsx
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	Datum	Belopp ($)
4	2023-11-18	10 231
5	2023-11-25	10 247
6	2023-11-27	11 121
7	2023-12-02	11 166
8	2023-12-04	11 583
9	2023-12-11	11 614
10	2023-12-18	11 645
11	2023-12-25	11 676
12	2024-01-01	11 707
13
14
15
graph

Cell Formulas
Range	Formula
C12	C12	=11676+31

 

[rexcel3]

If it is a permanent difference ie you are showing both the table and chart in your report and you want one ascending and one descending then you can tell the Chart Axis to show in reverse order.
• Select the Horizontal Lables in the chart.
• Right click > Format Axis (or Ctrl+1)
• Check the box on the last item under Axis Options "Dates in reverse order"


View attachment 104261

when i tried this, i believe the y-axis went to the right side of the line-chart.

 

[rlv01]

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.

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.