Support Board
Date/Time: Fri, 28 Feb 2025 17:56:55 +0000
Post From: Chart doesn't update with new spreadsheet values
| [2021-08-14 15:47:28] |
| Botan626 - Posts: 294 |
|
Using SC v2296. Spreadsheet study outputs data from the Pivots Points Daily study on the source chart #2 to sheet #2 of 'Pivots' Spreadsheet. Then another Spreadsheet study on the destination chart #1 uses data from sheet #2 of 'Pivots' Spreadsheet to calculate formulas on sheet #1 of Pivots Spreadsheet. If I change date range on the source chart, pivot lines on the destination chart won't update, until I press Chart -> Recalculate. But the Spreadsheet always produces correct values for pivot lines, columns O-U. If I put a plain number in the K column in sheet #1 and draw the K line on the chart, line on the chart updates every time I update number in the K column. Maybe there is a calculation precedence issue, but even so, why pivot lines on the destination chart don't update every time, when values change in the formula columns? Date Time Of Last Edit: 2021-08-14 15:47:42
|
 02.Cht - Attached On 2021-08-14 15:46:17 UTC - Size: 12.75 KB - 273 views Pivots.scss - Attached On 2021-08-14 15:46:31 UTC - Size: 41.07 KB - 348 views |