Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Charting / April 2007

Tip: Looking for answers? Try searching our database.

Log chart error

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Sandy - 28 Apr 2007 15:10 GMT
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 - 28 Apr 2007 16:19 GMT
>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!

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

Jon Peltier - 28 Apr 2007 20:09 GMT
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
_______

>>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
[quoted text clipped - 16 lines]
>
> Somebody put us out of our misery!
Del Cotter - 28 Apr 2007 21:01 GMT
>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.

Signature

Del Cotter
NB Personal replies to this post will send email to del@branta.demon.co.uk,
   which goes to a spam folder-- please send your email to del3 instead.

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.