Support Board
Support Board
Search Board
Control Panel
View My Posts / Threads
Direct MessagesDate/Time: Sat, 27 Apr 2024 15:13:46 +0000
Post From: Spread Sheet formula to establish if the sheet is presently being outputted to from chart
| [2018-11-13 18:20:16] |
| Sawtooth - Posts: 3978 |
|
Can you think of a way to identify true or false if the data in a sheet is changing (connected to a chart)?
Try this:=$J$41<=A3 for chart updating = FALSE or =$J$41>=A3 for chart updating = TRUE In a chart that is updating, J41 will be greater than A3. |