ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Logarithmic scale question (https://www.excelbanter.com/charts-charting-excel/186039-logarithmic-scale-question.html)

LiveUser

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?

Bernard Liengme

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?




Jon Peltier

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?







All times are GMT +1. The time now is 11:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com