Support Board
Date/Time: Mon, 10 Feb 2025 02:00:06 +0000
Post From: NaN In Right Side Values Scale of Chart
| [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 |