Sorting legend in grouped bar chart by sort order column

[stevenmcginnis]

I want to make a grouped bar chart with Percent on the y-axis, and Lot Number on the x-axis, with each Lot Number grouped into four different bars each representing a different step in a process. I would like the steps within the Lot Numbers to be ordered based on their order within the process. I have included some sample data at the bottom of the post, and here is a picture of the desired outcome:

Desired Outcome

I made a sort order column and put this into the tooltip field but it still doesn't gice the option to sort the legend with it. At the moment the legend, and bars within each lot number, sort in alphabetical order. Is this possible to change?

Any help would be appreciated.

Regards,

Steven

PS: Here is an example of how the data might look:

Lot Number	Field	Value	Sort Order
1	harv	86	1
2	harv	82	1
3	harv	81	1
4	harv	82	1
5	harv	81	1
6	harv	82	1
7	harv	86	1
8	harv	84	1
9	harv	78	1
10	harv	80	1
11	harv	84	1
12	harv	82	1
13	harv	50	1
14	harv	82	1
15	harv	81	1
16	harv	82	1
17	Chrom	81	2
18	Chrom	107	2
19	Chrom	82	2
20	Chrom	133	2
21	Chrom	80	2
1	Chrom	69	2
2	Chrom	79	2
3	Chrom	80	2
4	Chrom	71	2
5	Chrom	74	2
22	Chrom	122	2
8	Chrom	84	2
6	Chrom	69	2
7	Chrom	78	2
9	Chrom	82	2
10	Chrom	64	2
11	Chrom	85	2
12	Chrom	93	2
23	Lo pH	84	3
24	Lo pH	98	3
17	Lo pH	72	3
18	Lo pH	80	3
19	Lo pH	72	3
20	Lo pH	73	3
21	Lo pH	79	3
1	Lo pH	77	3
2	Lo pH	72	3
3	Lo pH	84	3
4	Lo pH	80	3
5	Lo pH	86	3
6	Lo pH	76	3
22	Lo pH	74	3
7	Lo pH	71	3
8	Lo pH	69	3
9	Lo pH	70	3
10	Lo pH	77	3
11	UF/DF	25587	4
11	Lo pH	77	3
12	UF/DF	78	4
12	Lo pH	67	3
13	Chrom	81	2
13	Lo pH	62	3
13	UF/DF	78	4
14	Chrom	78	2
14	Lo pH	65	3
15	Chrom	83	2
15	Lo pH	67	3
14	UF/DF	77	4
16	Chrom	71	2
16	Lo pH	69	3
16	UF/DF	80	4

[stevenmcginnis]

Perfect, thanks @PowerUserR .

[PowerUserR · Accepted solution]

Hi,

Just a quick thouht would be to use the "sort by column" option in the data tab of your report. You could then sort the desired column by the created sort column.