Charting

S

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
 
A

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
 
Top