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 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.
13 Replies
- It is a lot easier to sort your data if you remove all empty rows.
- I can't remove it, because otherwise I will see my charts are one by one. They need free areas
- What if you simply increase the height of the rows so the chart fits in a single row entirely?
