Display a chart sorted by quantity in legend

[easycode]

hello all
I have a chart in msaccess, this chart has almost all the features in excel, let me try to explain

i have 4 products that were sold since january to december last year the chart is perfect but the legend displays the products in alphatical order insted of by quantity so it goes:

Huts
Pants
Shirts
Shoes

it suppose to be

Pants
Shirt
Shoes
Huts

this is kind of tricky even in excel cause in excel if you place the products in a certain order, the chart will come out in that order, but not in access.
The reason i dont do it in excel is because i need to automate many charts and then automatically export them into powerpoint.

Any idea would be appreciated

Thanks