Help, Omitting NA with graphs Excel 2007

[alabatusa]

Hi All

I have the following data set and wish to build a superimposed column graph,
although i wish to omit any values with NA from the graph. I just seem to get it working.
I know how to overlap, by simply overlap to 100% i can get 3 colums overlapped.
Although my problem lies in say the 2nd entry, is NA
although on my graph shows up as a 0.
Any help would be greatly appreciated.


0-49 50-99 100+



24 0 0
#N/A #N/A #N/A
6 0 0
56 56 0
2 0 0
14 0 0
47 0 0
#N/A #N/A #N/A
75 75 0
#N/A #N/A #N/A
5 0 0
#N/A #N/A #N/A
26 0 0
47 0 0
7 0 0
20 0 0
#N/A #N/A #N/A
3 0 0
11 0 0
#N/A #N/A #N/A
49 0 0
#N/A #N/A #N/A
66 66 0
#N/A #N/A #N/A
11 0 0
30 0 0
45 0 0
30 0 0
8 0 0
16 0 0
31 0 0
15 0 0
19 0 0
10 0 0
48 0 0
#N/A #N/A #N/A
12 0 0
#N/A #N/A #N/A
24 0 0
1 0 0
0 0 0
#N/A #N/A #N/A
19 0 0
18 0 0
#N/A #N/A #N/A
#N/A #N/A #N/A
11 0 0

 

[alabatusa]

Anybody? Help please? need this urgently
is it possible?

 

[jenpen]

Hi,

Perhaps you could avoid the #N/A results in your data by using

IFERROR(your-original-formula<YOUR formula original><YOUR formula>,"")

The null values won't be graphed.

 

[Derek Brown]

#N/A should be compeltely ignored by the chart, except in the Legend.
I use that feature, in some line charts, by replacing 0 (zero) with #N/A to prevent the line 'dropping' to the bottom of the chart.