Graph Plotting Zero Values

muaythai

Board Regular
Joined
Aug 24, 2004
Messages
60
Excel 2003.

I am wanting to prevent my graphs from plotting a value that equates to zero.

However the graphs use series that have formula in that will evaluate to zero until data is entered.

I have tried the following:-

1. Making the formula evaluate to "".

2. Checked for anything undet tools/options/chart.

3. Checked the chart sheets properties.

Surely this must be possible ? Anyone with any help would be much appreciated.

Thanks, MT.
 

Some videos you may like

Excel Facts

Test for Multiple Conditions in IF?
Use AND(test, test, test, test) or OR(test, test, test, ...) as the logical_test argument of IF.

GlennUK

Well-known Member
Joined
Jul 8, 2002
Messages
11,402
Instead of having the formula evaluate to zero make it evaluate to NA().

For example:
Code:
=IF(A1=0,NA(),A1)
 

Watch MrExcel Video

Forum statistics

Threads
1,118,535
Messages
5,572,754
Members
412,482
Latest member
arooshrana2
Top