Sort Table Data Only

[Otto79]

I have a multiple steps to take to finish out projects and would like to review the time it takes to complete each step. I need to keep the data in the the example table unsorted, but would like to display an associated bar chart that sorts the last column (days between) from smallest to largest. Creating a standard bar chart does not allow for the sorting of the chart data unless the table data is sorted in a corresponding manner.

I believe this need to be done via a pivot table, which I am not very experienced with. Any help is greatly apprecaited!

Location	Project	Step 1 Start	Step 2 Start	Days between Step1 to Step 2
WA	Project A	6/4/24	7/8/24	34
TX	Project B	2/2/24	2/25/24	23
CA	Project C	8/7/24	8/31/24	24

 

[Otto79]

Also, I don't necessarily need the location to display in the table

 

[Peter_SSs]

Welcome to the MrExcel board!

Is this what you want?

24 12 17.xlsm
	A	B	C	D	E	F	G	H	I	J	K
1	Location	Project	Step 1 Start	Step 2 Start	Days between Step1 to Step 2		Location	Project	Step 1 Start	Step 2 Start	Days between Step1 to Step 2
2	WA	Project A	4/06/2024	8/07/2024	34		TX	Project B	2/02/2024	25/02/2024	23
3	TX	Project B	2/02/2024	25/02/2024	23		CA	Project C	7/08/2024	31/08/2024	24
4	CA	Project C	7/08/2024	31/08/2024	24		WA	Project A	4/06/2024	8/07/2024	34
Sort

Cell Formulas
Range	Formula
G2:K4	G2	=SORT(A2:E4,5)
Dynamic array formulas.

 

[Otto79]

Thanks, but I need to keep the order of the data in the table as it displays. I only want to sort the data in the chart so it displays the "days between" smallest to largest. The current chart output based on the above table looks like the attached image; whereas I only need the data in the chart to sort smallest to largest. I repeated myself there, but I think this makes sense

 

[Peter_SSs]

I think this makes sense

It isn't entirely clear to me.

I need to keep the order of the data in the table as it displays.

In my post above the data is still in the same order (in columns A:E)

I only want to sort the data in the chart so it displays the "days between" smallest to largest.

I'm not certain what you mean by "data in the chart" as the chart is made from the data, but the data in columns G:K in my previous post is sorted by "days between", smallest to largest. Couldn't you just use the relevant columns from that to make your chart?

Or if you only want the two columns shown in your latest image then is this what you want?

24 12 17.xlsm
	A	B	C	D	E	F	G	H
1	Location	Project	Step 1 Start	Step 2 Start	Days between Step1 to Step 2		Project	Days between Step1 to Step 2
2	WA	Project A	4/06/2024	8/07/2024	34		Project B	23
3	TX	Project B	2/02/2024	25/02/2024	23		Project C	24
4	CA	Project C	7/08/2024	31/08/2024	24		Project A	34
Sort (2)

Cell Formulas
Range	Formula
G2:H4	G2	=CHOOSECOLS(SORT(A2:E4,5),2,5)
Dynamic array formulas.