Support Board
Date/Time: Thu, 23 Jan 2025 09:51:24 +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: 4162 |
|
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. |