Login Page - Create Account

Support Board


Date/Time: Sun, 16 Jun 2019 07:55:16 +0000



Seeing ss column values in separate graph

Support Request:
[2019-03-07 22:47:25]
User376341 - Posts: 28
Hi, looking an answer, found this:
"The remaining columns (M through Z, assuming the default of 16 formula columns) can be optionally graphed as well. To graph these columns on the chart, go to the Study Settings window for the Spreadsheet Study on the chart and set Draw Style to the desired style for the corresponding Subgraph."

Tried above but seeing graphing in main graph, it there a way to graph a spreadsheet column in a separate graph, pls
[2019-03-08 22:13:51]
John - SC Support - Posts: 973
The Spreadsheet columns are displayed in the Chart Region defined for the study itself. This is true for all studies. Therefore, if you want the display to be in a different Chart Region, you just have to change this on the study. Note that it is not possible to display some subgraphs in one region and some in another. It is the entire study that gets displayed in the region. If you want to display some subgraphs in one region and some in another, then you can either use multiple Spreadsheet Studies, or use the Subgraph Reference Study.

Refer to the following for how to set the Chart Region for a study:
https://www.sierrachart.com/index.php?page=doc/ChartStudies.html#ChartRegion
[2019-03-12 06:13:06]
User376341 - Posts: 28
that's sorted, thanks

Another question

what can I do to prevent the main graph from collapsing into a dotted line.

This is happening after changing the SG5 Draw style from Ignore to star, see attached
imagebefore.PNG / V - Attached On 2019-03-12 06:10:27 UTC - Size: 57.31 KB - 16 views
imageafter.PNG / V - Attached On 2019-03-12 06:10:43 UTC - Size: 49.57 KB - 16 views
Attachment Deleted.
[2019-03-12 16:54:25]
John - SC Support - Posts: 973
First thing is to make sure the Input Setting for the Spreadsheet Study for Draw Zero Values is set to No. The most likely thing that is happening is that there are some zero values in the particular subgraph you are wanting to display and this is what is causing the graph to contract. You will find the documentation for this Input setting here:
https://www.sierrachart.com/index.php?page=doc/SpreadsheetStudyInputs.html#DrawZeros

If that does not solve it, then you need to look at the values of that Subgraph and see where there are values out of range and see if there is a way to prevent those values from occurring. Or you can set the Spreadsheet to a scale of Independent, which would not contract the main Price Graph.

Otherwise, if there are other Subgraphs that you want displayed relative to the main graph, then you would have to create a separate Spreadsheet Study for that particular Subgraph and then set that study to a scale of Independent.

You will find the documentation for the Independent Scaling here:
https://www.sierrachart.com/index.php?page=doc/Scaling.html#ScaleRange

To post a message in this thread, you need to login with your Sierra Chart account:

Login

Login Page - Create Account