One of the simpler ways is to hide the rows for the cells that have zeros and
then plot the graph.

"kafoury123" wrote:

i have a set of data on a column that i`ll use to plot on a graph and find a
trendline for its behaviour...problem is: there is zero values in some cells
that were not calculated... i want to copy this data in a new column getting
rid of cells with zero value because it results in a wrong trendline...how
can i do this?please help
this is an example of what i mean:
1 1
3 3
4 4
0 6
6 3
3 1
0
0
0
1