Re: Zero Values in chart
- From: "Bernard Liengme" <bliengme@xxxxxxxxxxxxxxxxx>
- Date: Thu, 15 Dec 2005 09:30:52 -0400
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
>
.
- Follow-Ups:
- Re: Zero Values in chart
- From: Rajkumar
- Re: Zero Values in chart
- References:
- Zero Values in chart
- From: Rajkumar
- Zero Values in chart
- Prev by Date: Zero Values in chart
- Next by Date: Combining stack column chart and non stacked
- Previous by thread: Zero Values in chart
- Next by thread: Re: Zero Values in chart
- Index(es):
Relevant Pages
|
