Support Board
Date/Time: Tue, 04 Nov 2025 13:39:37 +0000
get data from spreadsheet in several chart region
View Count: 586
| [2022-02-08 10:13:55] |
| User719206 - Posts: 93 |
|
Hello , my question is simple, in a spreadsheet i get several data in column o p q r s t ... I would like to get this data in separate chart region . I Saw 2 solution : - the first one was to create differente spreadsheet in the same chart and give them a different region but it looks impossible to create several spreadsheet in a same chart. - The second thing that i try it's to use study reference or study absolute value for each column , but it's not working when a new bar is created the study don't respect the data in the different column. is there a way to do it ? |
| [2022-02-08 14:52:52] |
| Sawtooth - Posts: 4285 |
|
is there a way to do it ?
You are using the only 2 ways to do it: either separate spreadsheet studies, or referencing a spreadsheet subgraph with another study.The Study Subgraph Reference study is the simplest way. Also the Moving Average - Simple study, Based On the spreadsheet study and its subgraph, with a Length of 1. Or the Spreadsheet Formula study, with a formula like this in its Formula field: =ID1.SG1 Each of the above need to reference the spreadsheet study and the subgraph that you want to be in another Chart Region. |
| [2022-02-08 17:31:43] |
| User719206 - Posts: 93 |
|
Hello , Thanks for your answer!! Unfortunatly nothing is working, moving average , absolute valu , reference ... all this study doesn't update well when the data change , I need to recalculate the chart to get the good data. |
| [2022-02-08 18:06:06] |
| Sawtooth - Posts: 4285 |
|
You can add the Chart Recalculation - Periodic study to do this automatically.
|
| [2022-02-08 18:27:51] |
| User719206 - Posts: 93 |
|
ok i found the solution, we can just duplicate the spreadsheet , give them each one a differente chart region and one subgraph to display.
|
| [2022-02-08 19:04:21] |
| User719206 - Posts: 93 |
|
okkkkey I WAS not aware about this chart recalcultation study , thnak you verry much Tomgib , I will use it like this have a great day :)
|
To post a message in this thread, you need to log in with your Sierra Chart account: