Sorting and color of charts

[diegomarino]

Hi, can i sort the legendt? values are not sorted


ps can i change colors with vba?



---------------------------
in the following bar chart, values are not sorted as in the query

SELECT count(Cliente) AS [N° clienti], Sum(totale) AS [Totale portafoglio], trasferibile, switch([trasferibile]="negativo",1,[trasferibile]="improbabile",2,[trasferibile]="possibile",3,[trasferibile]="probabile",4,[trasferibile]="sicuro",5) AS TrasferibileNumFROM qryportafoglio
GROUP BY trasferibile
ORDER BY switch([trasferibile]="negativo",0,[trasferibile]="improbabile",2,[trasferibile]="possibile",3,[trasferibile]="probabile",4,[trasferibile]="sicuro",5) DESC;

i made a numeric custom field cause i want to give a specific order and not an alphabetical one. "Negativo" should be the last


thanks

[June7]

I doubt it.

I would probably build a legend "graphic" with textboxes and labels or a graphic app like Paint.

Should be able to change colors - at least I have played with that using classic MSGraph https://www.accessforums.net/showthread.php?t=29178. If you are using Modern Chart, I have no idea.

[diegomarino]

ok thanks.
If i figure out how to achieve that i'll show my results

[diegomarino]

I used the initial letter to sort the legend. It's already ok but i'm wondering, is it possible to use HTML format to make the first letter transparent?
with something like that: <p style="background-color:Tomato;">"1 <100" </p>? for every values? cause this is the part of the query i set those values

 Switch([totale]<100000,"<100k",[totale] Between 100000 And 299999,"100k-300k",[totale] Between 300000 And 499999,"300k-500k",[totale] Between 500000 And 699999,"500k-700k",[totale] Between 700000 And 1000000,"700k-1mln",[totale] Between 1000000 And 1999999,"1mln-2mln",[totale] Between 2000000 And 4999999,"2mln-5mln",[totale] Between 5000000 And 9999999,"5mln-10mln",[totale]>=10000000,">=10ml") AS [Taglio cliente]

[June7]

I should have said "I doubt it without modifying data".

Now I have to say No - Access can only process HTML in a Rich Text textbox and WebBrowser control.

The posted code does not show letter prefixes.

[diegomarino]

ok you're right.

yes, i posted the old sql, actually is just with the letter before the label.
Ok, i think it's enough for me this solution
thanks