Support Board
Date/Time: Sun, 15 Mar 2026 00:25:04 +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: 4316 |
|
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. |