Support Board
Date/Time: Tue, 04 Nov 2025 02:13:39 +0000
how to translate data from a spreadsheet into a graph (chartbook)
View Count: 958
| [2020-10-19 18:36:14] |
| User960573 - Posts: 15 |
|
Hello, I have a question how to translate data from a spreadsheet into a graph (chartbook). I use the data that the spreadsheet groups, but trying to display them on a graph in the form of lines, moving averages, and other indicators does not give anything. I used the links that are given on the site SCh, why does nothing work?
|
| [2020-10-19 19:46:27] |
| John - SC Support - Posts: 42737 |
|
Are you referring to the built-in Sierra Chart Spreadsheets or an external spreadsheet? For an internal spreadsheet, refer to the information here: Using the Spreadsheet Study: Step By Step Instructions to use the Spreadsheet Study If you are referring to importing the data from an external spreadsheet, then refer to the information here: Exporting and Importing Intraday Data Files: Import and Load For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-10-19 20:56:23] |
| User960573 - Posts: 15 |
|
Is there a tutorial video on how to add data from a table to a graph?
|
| [2020-10-19 21:22:16] |
| John - SC Support - Posts: 42737 |
|
Not within our documentation. You may be able to find something online from a user of the system. In general, you would want to use the Spreadsheet Study. Refer to the information here: Overview of Spreadsheet Studies: Introduction to Spreadsheet Studies For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2020-10-20 15:41:42] |
| User960573 - Posts: 15 |
|
Hello I have such a question! I use the data provided by indicator the Number Bars Calculated Values 2. This data (for example, the Median Ask volume and Median Bid volume) has formed as a table data in area 2 (in the image) how Visible in Draw Style. I want the values data from table (in area 2) below to be represented as Lines (for example) in the same area 2. How do I do this?
|
 qwestion to sch.jpg / V - Attached On 2020-10-20 15:41:03 UTC - Size: 391.77 KB - 257 views |
| [2020-10-20 15:57:05] |
| John - SC Support - Posts: 42737 |
|
The Numbers Bars Calculated Values 2 is always displayed as a table. There is no way to change that. So what you need to do is use the Study Subgraph Reference and set the subgraph that you want to draw as a line, bar, etc. in the Study Subgraph to Reference Input. You can then change the draw style as wanted to draw the data as you please. Refer to the information here: Study Subgraph Reference Note that you will have to put the Study Subgraph Reference in a different region from the Numbers Bars Calculated Values. Refer to the following: Chart Studies: Settings and Inputs Tab >> Chart Region Also, if you do not need to look at the Numbers Bars Calculated Values as a table, then you can hide that study. Refer to the information here for hiding a study: Chart Studies: Settings and Inputs Tab >> Hide Study 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: