Support Board

Date/Time: Fri, 03 May 2024 05:02:15 +0000

Post From: ALERT FORMULA QUESTION

[2020-01-13 20:21:42] Link To Thread - Link To Post [Go To First Post]
Sawtooth - Posts: 3992
If the formula is the same on all charts, simply duplicate the chart and a spreadsheet sheet will be added for the chart. This puts all charts in the same chartbook. The Formula Source Sheet Number will be the same as the original, and this is the sheet that contains the master formulas. You can edit the formula here and it will change on all other sheets. You therefore cannot edit the formula on sheets where its Formula Source Sheet Number does not match the sheet number. If you want separate chartbooks, IMO it is best to use a uniquely named spreadsheet file for each chartbook, if they are to be used concurrently. To 'duplicate' a chartbook, go to File >> Save As and give it a new name. To rename a spreadsheet file, Save As it to another name, then select the new one in the Spreadsheet Name field of the spreadsheet study settings.