Hi Larisa, in the Sort tab you can set the order of any chart.
Anyway, if you want the load order in QV to be by Brand you can do:
(ooxml, embedded labels, table is data);
NoConcatenate LOAD * Resident Excel Order By Brand;
DROP table Excel;
I did as suggested. Then I created a list-box and set the load order for this list-box. But I see that the load order is not alphabetic. See the file attached.
test1.qvw 147.0 K
OK, as it is the same field, the loading sort order for Brand is set in the first load, you can try with:
LOAD Brand as Brand_Orig,
(ooxml, embedded labels, table is data)
NoConcatenate LOAD Brand_Orig as Brand, [Cost RUB] Resident Source1 Order By Brand_Orig
DROP table Source1;
This way the load order of Brand_Orig don't mess with the load order of Brand.
test1.qvw 146.8 K