Log chart error

[Sandy]

I have a chart which shows logarithmic values. The chart data is supplied
from a table that increases in size for every entry. Problem is that when
the table is in its infancy a message pops up to say "Negative or Zero
values on log charts etc etc". Is there any way to prevent this from popping
up. The chart values will never be negative and will only be Zero for the
first few entries max.

Thanks in advance
Sandy

 

[Del Cotter]

I have a chart which shows logarithmic values. The chart data is supplied
from a table that increases in size for every entry. Problem is that when
the table is in its infancy a message pops up to say "Negative or Zero
values on log charts etc etc". Is there any way to prevent this from popping
up. The chart values will never be negative and will only be Zero for the
first few entries max.

Sadly, no, to the best of my knowledge. The warning drives me mad
because the charts in question are just fine and we're grown up enough
to take the warning on board the first time.

I have a chart that I had to abandon a clever dynamic range technique
for, and use an awkward set of manually-adjusted ranges instead, because
it kept displaying that insane message every time during the design. I
couldn't even find the zero, negative, or other unacceptable values it
was objecting to. They may have been in the error bars, but I looked
there as well.

Somebody put us out of our misery!

 

[Jon Peltier]

It may have been a blank cell or text item somewhere in the range.

- Jon

 

[Del Cotter]

It may have been a blank cell or text item somewhere in the range.

That's the thing, I never did find the pesky critter, and I suspected it
had to do with some (necessary) conditional values in my
otherwise-beautiful named range formulae, so in the end I gave up and
split up the input data range manually, which I didn't want to do.