Help with special print preview format

[steve]

Hello,
This is kind of difficult to explain so I will show a small example what
I am trying to accomplish.
Lets say I have a spreadsheet like the following:
Date Time Day Evening Night 24hrs. total avg. cc\day
avg. cc\week
3/23/04 6:00 200
8:00 450
11:00 100
12:00 0
750
31.25
*
Date Time Day Evening Night 24hrs. total avg. cc\day
avg. cc\week

3/31/04 6:00 0
7:00 0
0
0 107.14
*Note the example above will have more values for more date during the
week but this just a small example.

Now from this example I would like the following:
1) Create a line chart with a line with markers displayed a each data value
(I know how to do this part) but I don't want to show the zero values on the
chart but only show it on the spreadsheet how can this be done.

Any help to this would really be appreciated.

 

[Frank Kabel]

Hi Steve
- normally I would try to change the zeros to the formula =NA()
as these values won't be displayed in your chart. You can then use
conditional formating to hide these entries.
But if you have to display zeros on your sheet maybe the following
example will help you:
http://andypope.info/charts/piezeros.htm