Support Board
Date/Time: Fri, 26 Apr 2024 10:38:27 +0000
Seeing ss column values in separate graph
View Count: 682
[2019-03-07 22:47:25] |
User376341 - Posts: 37 |
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: 31131 |
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: Chart Studies: Settings and Inputs Tab >> Chart Region For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
[2019-03-12 06:13:06] |
User376341 - Posts: 37 |
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 |
before.PNG / V - Attached On 2019-03-12 06:10:27 UTC - Size: 57.31 KB - 226 views Attachment Deleted. |
[2019-03-12 16:54:25] |
John - SC Support - Posts: 31131 |
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: Spreadsheet Study Inputs: Draw Zero Values 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: Chart Scale and Scale Adjusting: Scale Range (Scale Settings) For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
To post a message in this thread, you need to log in with your Sierra Chart account: