Zero Values in chart

Rajkumar · #1 12-15-2005, 08:23 AM

Hi,

Is there any way to avoid displaying zero values in a chart.

Raj

#2 12-15-2005, 08:35 AM

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@excelforum-nospam.com> wrote in
message news:Rajkumar.2032bn_1134653101.7113@excelforum-nospam.com...
>
> 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...fo&userid=2159
> View this thread: http://www.excelforum.com/showthread...hreadid=493770
>

Rajkumar · #3 12-15-2005, 09:04 AM

Thanks Bernard,

But my Source Data is depended on some formulaes,hence when the result of them returns zero,the same gets displayed in the chart also.

Is there any other way.

I am sure you can help me.

Regards,
Rajkumar

#4 12-15-2005, 10:10 AM

Hi,

Use Bernard's suggestion of NA() in your formula. Something like,

=IF(test<>0,test , =NA() )

Cheers
Andy

Rajkumar wrote:
> Thanks Bernard,
>
> But my Source Data is depended on some formulaes,hence when the result
> of them returns zero,the same gets displayed in the chart also.
>
> Is there any other way.
>
> I am sure you can help me.
>
> Regards,
> Rajkumar
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

#5 12-16-2005, 12:10 AM

Take out the internal "=":

=IF(test<>0,test,NA())

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

"Andy Pope" <andy@andypope.info> wrote in message
news:eiH9ZkYAGHA.3140@TK2MSFTNGP14.phx.gbl...
> Hi,
>
> Use Bernard's suggestion of NA() in your formula. Something like,
>
> =IF(test<>0,test , =NA() )
>
> Cheers
> Andy
>
> Rajkumar wrote:
>> Thanks Bernard,
>>
>> But my Source Data is depended on some formulaes,hence when the result
>> of them returns zero,the same gets displayed in the chart also.
>>
>> Is there any other way.
>>
>> I am sure you can help me.
>>
>> Regards,
>> Rajkumar
>>
>>
>
> --
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info

#6 12-16-2005, 04:15 AM

Thanks Jon, too lazy with my cut & paste

Jon Peltier wrote:
> Take out the internal "=":
>
> =IF(test<>0,test,NA())
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Peltier Technical Services
> Tutorials and Custom Solutions
> http://PeltierTech.com/
> _______
>
>
>
> "Andy Pope" <andy@andypope.info> wrote in message
> news:eiH9ZkYAGHA.3140@TK2MSFTNGP14.phx.gbl...
>
>>Hi,
>>
>>Use Bernard's suggestion of NA() in your formula. Something like,
>>
>>=IF(test<>0,test , =NA() )
>>
>>Cheers
>>Andy
>>
>>Rajkumar wrote:
>>
>>>Thanks Bernard,
>>>
>>>But my Source Data is depended on some formulaes,hence when the result
>>>of them returns zero,the same gets displayed in the chart also.
>>>
>>>Is there any other way.
>>>
>>>I am sure you can help me.
>>>
>>>Regards,
>>>Rajkumar
>>>
>>>
>>
>>--
>>
>>Andy Pope, Microsoft MVP - Excel
>>http://www.andypope.info
>
>
>

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info

Welcome to the Excel Forum

Forum Statistics