Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 90
Default Logarithmic scale question

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?
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 4,393
Default Logarithmic scale question

Please clarify. What does "Logarithm" in subject line have to do with this?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"LiveUser" wrote in message
...
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?



  #3   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 6,582
Default Logarithmic scale question

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
_______


"Bernard Liengme" wrote in message
...
Please clarify. What does "Logarithm" in subject line have to do with
this?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"LiveUser" wrote in message
...
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?





Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help on logarithmic scale pj_raesh Charts and Charting in Excel 1 July 23rd 06 11:44 AM
In the x axis, logarithmic scale Charles Charts and Charting in Excel 3 April 20th 06 06:15 PM
logarithmic scale on x-axis Daniel Charts and Charting in Excel 1 March 9th 06 02:28 AM
Logarithmic Scale - Tic Label Disappearance howie1 Charts and Charting in Excel 2 January 16th 05 01:06 PM
How I can do on x-axis, logarithmic scale? logarithmic scale on x-axis Excel Discussion (Misc queries) 1 December 5th 04 05:36 PM


All times are GMT +1. The time now is 05:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"