Oct 17 2021 08:50 PM
There are 3 rows: 5, 11, 17.
In columns P5, P11, P17 there are the places in the rating. I want to see, if P11= 1st place in rating it moves on the top table(1st row) (in my case it can be P5), and if P5 = 2nd place in rating I want to see it on 2nd rows (in my case it can be P11).
But I also want to see the connection between Q5 and her own the chart. If P5=2, so it should move to 2nd row, and Q5 with her own the chart should move to 2nd row.
Oct 18 2021 04:54 AM
Oct 19 2021 12:12 AM
Oct 19 2021 02:04 AM
Oct 19 2021 07:38 PM
@Jan Karel PieterseI remoted a few rows and I think this is the latest version. I cannot remove other rows because there is data associated with them
Oct 20 2021 12:27 AM
Oct 20 2021 02:16 AM
@Jan Karel Pieterse I changed my book, I think now I can see all info
Oct 20 2021 02:30 AM
@Maksim7570 I meant something like the attached, where I placed the charts next to the table. You can sort the table in any order you like, the charts should refer to the row that they are on.
Oct 20 2021 03:25 AM
Oct 20 2021 05:12 AM
@Maksim7570 LIke this (change the numbers in column A or B, the charts and the table on the right update automatically). This version only works with Excel 365
Oct 20 2021 07:27 PM
Oct 21 2021 01:23 AM
@Maksim7570 Sure!
Oct 21 2021 01:46 AM
I saw what you did, but I don't understand how I can use it in this sheet (look at the picture)
Oct 21 2021 02:17 AM