Re: Zero Values in chart

Assuming you mean you want empty cells not to be treated as zeros:
1) click on chart; use Tools|Options|Chart and specify how you want blanks
to be treated
or
2) replace blanks by =NA()
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Rajkumar" <Rajkumar.2032bn_1134653101.7113@xxxxxxxxxxxxxxxxxxxxx> wrote in
message news:Rajkumar.2032bn_1134653101.7113@xxxxxxxxxxxxxxxxxxxxxxxx
>
> Hi,
>
> Is there any way to avoid displaying zero values in a chart.
>
> Raj
>
>
> --
> Rajkumar
>
> Eager to learn more about Excel
> ------------------------------------------------------------------------
> Rajkumar's Profile:
> http://www.excelforum.com/member.php?action=getinfo&userid=2159
> View this thread: http://www.excelforum.com/showthread.php?threadid=493770
>


.

Relevant Pages