Support Board
Date/Time: Sun, 12 Jan 2025 14:59:58 +0000
Post From: [User Discussion] How to display text and lines from a spreadsheet
| [2017-02-20 01:05:34] |
| Sawtooth - Posts: 4149 |
|
Without using ACSIL, it's not possible to display text on a chart from a spreadsheet cell, with this exception: -Text at the right edge, or in the fill space, of a formula output from a row 2 cell of the same Formula Column, when using the Name Label. Despite its name, the Text Display For Study study only displays numerals. As for drawing lines from a spreadsheet, this can best be done using the Spreadsheet Study study. Instead of using Excel, you could add a Sheet that is not associated with a chart where your values are located, then reference those cells in Formula Columns on the sheet that is associated with the chart. The Spreadsheet Study allows you to use Excel, but no support is provided if there are issues, and the functionality does not auto-populate cells in 'Formula Columns'. You may be able to make this work, but it might be more trouble than using the built-in Spreadsheet Study. http://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#UseExcel |