Errors in Charts

[chaitreya]

The enclosed sample excel ‘Chart’ is about plotting charts of intra-day quotes from Google finance.
In RTData sheet, we get such data with an interval of 60 sec (1 min)
In RTCal sheet, =IF(RTData!="",NA(),RTData!) is used to avoid zero data.
However,
In chart at sheet RTG, the closing price falls to zero for the data that is to be uploaded.
Can someone please help me to rectify this error ?
Again, the Y-Axis range (which is set ‘Auto’) became too large…
It should be +/- 20 from closing price’s high and lows. (any help on this too ??)

[Andy Pope]

The final row, 377 contains zero rather than #N/A so the line is drawn between last 2 valid data values.

[chaitreya]

Ohhhh
what a sily mistake by me
(that row was filled with dark color)

thanks a lot for pointing out.