Support Board
Date/Time: Sat, 26 Sep 2026 02:01:37 +0000
Plotting from Spreadsheet Study
View Count: 38
| [2026-09-25 18:49:13] |
| User841161 - Posts: 351 |
|
Spreadsheet Study shows NaN when using Independent left-side scale I have a /CL chart with a Spreadsheet Study in Chart Region 1. SG4 of the Spreadsheet Study contains an adjusted USO price series and plots correctly when the study Scale Range is set to Automatic. I want /CL to use the right-side scale and SG4 (Adjusted USO) to use an independently scaled left-side scale. I have: - Chart Settings → Scale → Use Left Side Scale = Yes - Main Price Graph → Automatic - Spreadsheet Study → Scale Range = Independent - Spreadsheet Study → Use In Left Side Scale = Yes - SG4 Draw Style = Line When I change the Spreadsheet Study from Automatic to Independent, SG4 disappears and the left-side scale displays NaN. When I change it back to Automatic, SG4 immediately displays correctly with valid values around 149. The spreadsheet cells feeding SG4 contain valid numeric values with no apparent errors. Is there another setting required for a Spreadsheet Study to use Independent scaling on the left side in the same chart region as the Main Price Graph? |
 Main_Automatic_Spreadsheet_Independent.png / V - Attached On 2026-09-25 18:48:49 UTC - Size: 25.18 KB - 5 views MainChart_Automatic_SpreadsheetStudy_Automatic.png / V - Attached On 2026-09-25 18:48:57 UTC - Size: 33.29 KB - 4 views |
| [2026-09-25 19:10:32] |
| John - SC Support - Posts: 48028 |
|
We are not seeing any issue with this. When we set the Spreadsheet to Independent and use the left-side scale, it is showing correctly in the scale and we do not have the "NaN" that you are getting. The first thing to do is to try to reset the left side scale. Please try right-clicking in the left-side scale and then select "Reset". If the right-click options do not show, then try a "double left-click" to do the reset. Let us know if one of these resolves the issue or if you still have a problem. For the most reliable, advanced, and zero cost futures order routing, use the Teton service: Sierra Chart Teton Futures Order Routing |
| [2026-09-25 19:36:56] |
| User841161 - Posts: 351 |
|
The first thing to do is to try to reset the left side scale. Please try right-clicking in the left-side scale and then select "Reset". This worked! Thanks!
|
To post a message in this thread, you need to log in with your Sierra Chart account: