Making a worksheet and a graph that doesn't show zero values

  • Thread starter Thread starter Big Kiwi
  • Start date Start date
B

Big Kiwi

Hi
I am trying to build a template worksheet for my research. I get a file of
logged data per day. I want to be able to copy the logged data from a .CSV
file to a template file. Then separate worksheets will look at the raw data
and import data from certain columns into that worksheet.

The data is not logged in a regular way, there can be 30 cells between
logging intervals or 29 or 31 cells. I can select that every cell in a
column of Worksheet 1 looks at a set cell in the "Raw Data" worksheet. This
will then give me a column consisting of logged data values with zeroes in
between. When I want to graph the data, I don't want the zeroes to appear on
the graph. Is there a way I can import data from one worksheet to another,
where if the value is zero then no value is displayed AND when this data is
then graphed those zeroes don't appear? I can import data and not display
zeroes in the worksheet, I just can't get it to do that AND get the graph to
do what I want.

I would appreciate someone's help.
 
Big Kiwi said:
Hi
I am trying to build a template worksheet for my research. I get a file
of
logged data per day. I want to be able to copy the logged data from a .CSV
file to a template file. Then separate worksheets will look at the raw
data
and import data from certain columns into that worksheet.

The data is not logged in a regular way, there can be 30 cells between
logging intervals or 29 or 31 cells. I can select that every cell in a
column of Worksheet 1 looks at a set cell in the "Raw Data" worksheet.
This
will then give me a column consisting of logged data values with zeroes in
between. When I want to graph the data, I don't want the zeroes to appear
on
the graph. Is there a way I can import data from one worksheet to
another,
where if the value is zero then no value is displayed AND when this data
is
then graphed those zeroes don't appear? I can import data and not display
zeroes in the worksheet, I just can't get it to do that AND get the graph
to
do what I want.

I would appreciate someone's help.
Click to expand...


You could create a new column with formulas pointing to the original data.
If the original data is 0 have the formula return the NA() function, this
will prevent the 0 appearing on the graph.
Now this does make the original data look messy so you can put some
conditional formatting on the cells so that if the cell value is NA() then
the text is the same as the colour as the background so it is invisible.

Alteratively do a global replace on your raw data changing all 0 values to
blanks to prevent them showing.
 
Back
Top