Date/Time: Sun, 31 May 2020 15:59:49 +0000
Post From: Keeping spreadsheets light
|Bedhog - Posts: 148 | Ending Date: 2020-09-27|
This is my workaround for the cell references.
When adding new studies to a chart, move them down to the bottom of the "Studies to Graph" list. This has allowed my spreadsheets and defined cell references to remain intact because the new study outputs will appear in the unused cells far to the right in the spreadsheet. If you find that you don't want that study, but suddenly find out it will jazz your references, just hide the study so it no longer shows up on the chart. If you are using a low number of rows, the impact should be minimal on a capable computer.