Forum Discussion
how to physically move rows along with the chart depending on the cell value?
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 ...
JKPieterse I changed my book, I think now I can see all info
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.
- That is my point, your current design makes this very hard to do, mine is a lot simpler and enables automatic sorting of the data into a top-3, including the charts.
I saw what you did, but I don't understand how I can use it in this sheet (look at the picture)
Maksim7570 Sure!
- I see what you do, but I don't have Excel 365. Maybe there are other formulas or macros?
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
- You didn't understand me. I want to see automatically changing in my book.
For example, sheet "Лист1", if P10=1, row 10 should move to row 4. And if P7=3, row 7 move to 10 etc.
