getting rid of zero values in a column

[kafoury123]

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

[Raj]

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
>

[kafoury123]

how can i ommit the zero values cells automaticaly..not manualy??

"Raj" wrote:

> 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
> >