?
Solved

Zeros on a logarithmic scale

Posted on 2012-08-21
3
Medium Priority
?
590 Views
Last Modified: 2012-09-05
By definition zeros cannot be represented on a logarithmic scale.  So, a log graph which contains zeros is problematic.  Is there a way to get Excel to ignore these values and stop giving persistent error messages?
0
Comment
Question by:karaflanagan
  • 2
3 Comments
 
LVL 15

Accepted Solution

by:
gplana earned 2000 total points
ID: 38316625
You can add an IF inside your formula:

http://spreadsheets.about.com/od/excelfunctions/qt/07-if-function.htm

Something like

=if(a1=0, 'No zeros on logaritm', log(a1))

Hope it helps
0
 

Author Comment

by:karaflanagan
ID: 38316680
gplana:

Thanks for the suggestion, but where would I add the formula as I am building the chart to make it ignore the zeros?
0
 
LVL 15

Expert Comment

by:gplana
ID: 38316743
if you want to ignore, I think you should force an error value, such as an empty string. Put the if inside the formula you have and see what happens in graph.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Windows Explorer let you handle zip folders nearly as any other folder: Copy, move, change, and delete, etc. In VBA you can also handle normal files and folders, but zip folders takes a little more - and that you'll find here.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
This Micro Tutorial demonstrate the bugs in Microsoft Excel for Mac with Pivot Charts.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question