Log chart error
 

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

Log chart error
 

On Sat, 28 Apr 2007, in microsoft.public.excel.charting,
Sandy said:

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!

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.

Log chart error
 

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

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


"Del Cotter" wrote in message
...
On Sat, 28 Apr 2007, in microsoft.public.excel.charting,
Sandy said:

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!

--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.

Log chart error
 

On Sat, 28 Apr 2007, in microsoft.public.excel.charting,
Jon Peltier said:
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.

--
Del Cotter
NB Personal replies to this post will send email to ,
which goes to a spam folder-- please send your email to del3 instead.