Forum Discussion
Helper VChart data contains not a number (NaN) values
Advocate IThank goodness for this thread. It has saved my sanity. I had the same NaN error message as MarkCBB on many stacked column charts in a large report. Nothing I tried would fix the issue. I could create identical charts to the ones displaying the error, and they had no error! The only solution appeared to be to recreate all the problem charts :-(.
So I follow Mark's lead and look for a trendline. But my charts have non-numerical X axes and the Trendline option didn't appear in the Analytics pane. But if I changed the chart to a line chart and changed the X axis to something numerical (I used the Date column from my date table), the Trendline option appeared, a trendline was indeed present, and deleting it, then reversing the X-axis and chart type changes fixed the issue.
Apparently, the person who initially created the charts (not me) added trendlines, but then changed the chart type and X-axis. So the trendline was hiding there all the time causing the NaN warning, even though it was not accessible in the Analytics pane. Very tricky.
Helper IOh my gosh! You are my hero. This is exactly my issue. Bloody disappearing Trendline option. Ha.
Cheers!
SteelBreeze wrote:Thank goodness for this thread. It has saved my sanity. I had the same NaN error message as MarkCBB on many stacked column charts in a large report. Nothing I tried would fix the issue. I could create identical charts to the ones displaying the error, and they had no error! The only solution appeared to be to recreate all the problem charts :-(.
So I follow Mark's lead and look for a trendline. But my charts have non-numerical X axes and the Trendline option didn't appear in the Analytics pane. But if I changed the chart to a line chart and changed the X axis to something numerical (I used the Date column from my date table), the Trendline option appeared, a trendline was indeed present, and deleting it, then reversing the X-axis and chart type changes fixed the issue.
Apparently, the person who initially created the charts (not me) added trendlines, but then changed the chart type and X-axis. So the trendline was hiding there all the time causing the NaN warning, even though it was not accessible in the Analytics pane. Very tricky.