Support Board
Date/Time: Wed, 19 Mar 2025 14:35:58 +0000
Post From: Spreadsheet with Random Zeros
| [2022-10-19 15:01:48] |
| Sawtooth - Posts: 4186 |
|
If you add, remove, or rearrange studies in the Studies to Graph list, data in newly unused columns is not cleared. You can clear the data by highlighting all columns AA and above, then do a Chart >> Recalculate. If you use alphanumeric cell references of study outputs in columns AA and above, and you add, remove, or rearrange studies in the Studies to Graph list, formula references will not follow the column changes; they will reference the wrong columns. It is recommended that you use this cell reference method instead (for referencing study output columns AA and above): Working with Spreadsheets: References to Study Subgraph Columns when using the Spreadsheet Study This will allow you to make these changes without misaligned references: - Add, remove, or rearrange studies in the Studies to Graph list. - Change the Number of Formula Columns setting. - Insert/Delete Formula Columns. |