You could always write a macro that replace all the cells with a value of 0

"Shhhh" wrote:

>
> Hello all,
>
> Is it possible to create a chart using an entire column, but have the
> chart
> ignore all 0 values? i.e. simply not plot the 0 values.
>
> Thanks,
> Shhhh
>
>
> --
> Shhhh
> ------------------------------------------------------------------------
> Shhhh's Profile: http://www.excelforum.com/member.php...o&userid=28094
> View this thread: http://www.excelforum.com/showthread...hreadid=475985
>
>