Charting

[SD]

I have a created a trend . However for a couple of year data points
the values are blank. Since there is formula embedded in those cells I
really dont want to touch it. So when I graph over it it would show as
0 . In graphs we would be seeing all Zig Zag lines. If I want the data
points to maintain the flow from where the last data point was
available and not let the line drop to zero is that possible to excel
graphs ? Or should I put another condition in the cell to pick the
previous cell incase its blank or 0 or no value ? Any way out ?

Appreciate all your help in advance.

thanks
SD

 

[Andy Pope]

Hi,

In order to get the chart to interpolate those cells with formula but no
data you need to modify your formula to return NA() instead of "" or 0.

Cheers
Andy