If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Making a worksheet and a graph that doesn't show zero values
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. |
#2
|
|||
|
|||
Making a worksheet and a graph that doesn't show zero values
|
Thread Tools | |
Display Modes | |
|
|