Re: Help with special print preview format

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/23/04 

Date: Sun, 23 May 2004 10:08:21 +0200

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 *** maybe the following
example will help you:
http://andypope.info/charts/piezeros.htm 

--
Regards
Frank Kabel
Frankfurt, Germany
steve wrote:
> 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 spread*** 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 spread*** how can this
> be done.
>
> Any help to this would really be appreciated.
Loading