graph with specific data

The most difficult right now in this question is to explain my problem with short and clear way - anyway let me try
I am using relatively old APEX 5.   

In fact it is continuation of my previous question :
https://community.oracle.com/mosc/discussion/comment/16841626#Comment_16841626

So to summarize I have a set of data like below:

DAY      LTR   Q   RANK
1.01.2021 A     30  3
1.01.2021 B     20  4
1.01.2021 D     50  1
1.01.2021 S     40  2
1.01.2021 OTHER 300  99
2.01.2021 K     50  2
2.01.2021 A     40  3
2.01.2021 S     90  1
2.01.2021 OTHER 200  99
3.01.2021 B     70  1
3.01.2021 A     30  3
3.01.2021 C     60  2
3.01.2021 H     20  4
3.01.2021 OTHER 180  99


First column is obviously date, second is a unique letter, third quantity of this letter and the last one is a daily ranking top 4 .As you see there is also LTR called OTHER which is a quantity of all other letters counted together and ranked in the last ( in my case 99th ) position