I created a line graph which will show data daily basis (every 30 sec data). There are points in the data where it reads 0. I have a requirement to remove all those zeros but when there is 4 or more then 4 consecutive data points with 0 reading then show them all.I am plotting 10 parameters on the time stamp and each has multiple data drops (0's).
Thanks in advance.
It's very difficult to understand your request without the data and illustrations.
Please add packaged workbook and explain each filed, cell more clearly.