What type of chart are you using? Jon Peltier provides several examples of
how you can handle gaps, and how different chart types vary at:
http://peltiertech.com/WordPress/min...g-empty-cells/
--
Best Regards,
Luke M
"LiAD" wrote in message
...
Hi,
Thanks for the suggestion.
I'm afraid the chart engine (or at least mine anyway) doesn't ignore it -
it
plots nothing on the graph but shows a lot of empty space which
increases/decreases as i add/delete N/A's.
If i try this technique on a chart without dynamic ranges it doesnt work
either.
Any ideas why this would be different to your result?
Thanks
"Bernard Liengme" wrote:
Replace the blank by #N/A
So let's say your formula is =IF(this-test, B2,"") then use
=IF(this-test,B2,NA())
When the test fails, this displays #N/A which the chart engine ignores
If this looks odd in a print out, use a conditional format such as
=ISNA(C2)
and make the font the same as the cell background - make it invisible on
the
screen and then printed.
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
"LiAD" wrote in message
...
Hi,
In a chart I have a formula that either returns a number or "" in a
cell.
I
then have a dynamic range set which plots the values on a graph. The
problem
is that the chart will plot the ""s as zeros as it sees something in
the
cell.
Is there a way I can have a true blank cell result coming from a
formula?
If not how I can avoid the dynamic range seeing this as a zero?
Thanks
LiAD
.