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 / May 2008

Tip: Looking for answers? Try searching our database.

Logarithmic scale question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
LiveUser - 02 May 2008 20:24 GMT
I have some zero values on my pivot chart and, as far as I know, I don't have
the option to hide the zeros or get rid of them.

How can I get rid of the zeros?
Bernard Liengme - 03 May 2008 20:37 GMT
Please clarify. What does "Logarithm" in subject line have to do with this?
best wishes
Signature

Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

>I have some zero values on my pivot chart and, as far as I know, I don't
>have
> the option to hide the zeros or get rid of them.
>
> How can I get rid of the zeros?
Jon Peltier - 03 May 2008 22:06 GMT
I suspect LU has changed to a log scale, and the zeros and blanks lead to
the helpful warning about taking logs of zero values.

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

> Please clarify. What does "Logarithm" in subject line have to do with
> this?
[quoted text clipped - 4 lines]
>>
>> How can I get rid of the zeros?
 
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



©2009 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.