Support Board
Date/Time: Sun, 09 Feb 2025 06:12:20 +0000
[Programming Help] - NaN In Right Side Values Scale of Chart
View Count: 884
| [2020-08-13 01:37:01] |
| CMG - Posts: 179 |
|
Hi There, When trying to plot values in a chart from a formula column (column P) in a spreadsheet for trading study nothing is plotted and right-side values scale shows NaN (Not a number). I made sure that the study is on region 2 and there are no other studies applied to the chart that can make a conflict. Also, all sub-graphs from the spreadsheet study (except column P) are set to ignore. Subgraph for column P is set to (Draw Style) Line and all values in column P are a number and not divided by 0. It does not matter what number is entered into column P, NaN always shows in R-S values scale. Different scale settings combinations do not help either. Strangely another instance of the same spreadsheet in another chart in same chartbook with same values and settings does not produce the NaN error. The only change to R-S values scale is when a fractional (1/2, 1/4, etc.) is selected in Value Format and then 2147483 is shown in the R-S Values Scale. This number (2147483) is always shown in the scale with any number (even a constant) in column P of the spreadsheet! Any clues? Thanks |
| [2020-08-13 17:30:55] |
| |
|
You really need to determine what exactly you are doing in the calculations and examine the input values, which is leading to this. We do not know.
Sierra Chart Support - Engineering Level Your definitive source for support. Other responses are from users. Try to keep your questions brief and to the point. Be aware of support policy: https://www.sierrachart.com/index.php?l=PostingInformation.php#GeneralInformation For the most reliable, advanced, and zero cost futures order routing, *change* to 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: