Connection of Dashboards

Hello, guys, I’m using the lalest browser Grafana version, and Ihave a question: is there any way to connect different panel from one dashboard? I want to create a dashboard where if one panel’s value changes, the changes also occur on the other one. For example, I have Expected Income, and Real Income - a panel, which colour is dependant on how close it is to Expected one. So, if I change the value of Expected Income from 25k$ to 20k$, and my Real Income is 18k$, I want it to turn from red to yellow, because now it is closer. My Data Source is Google Sheets, so I have static values that renew every day. Is there any way to perform that type of task? Looking forward to hearing about it!