 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
11-21-2005, 10:00 PM
|
|||
|
|||
|
avoiding plotting zero values on graphs
How do I when plotting points of a graph avoid plotting the zero values.
During the start of a new period, there will be several zero values, how can i aviod excel from plotting these zero values 
|
|
#2
11-21-2005, 10:20 PM
|
|||
|
|||
|
Re: avoiding plotting zero values on graphs
"Lee" <Lee@discussions.microsoft.com> wrote in message
news:9D957426-691B-49B3-A846-509B09EF8BFF@microsoft.com > How do I when plotting points of a graph avoid plotting the zero > values. > > During the start of a new period, there will be several zero values, > how can i aviod excel from plotting these zero values > Hi Lee, I suggest that, unless the result you want *is* actually zero, you don't have a formula that returns that value. Better, IMO at least, to return Not Applicable (#N/A) if the result is not (yet) applicable. For example: =IF(DataMonth>CurrentMonth,NA(),Result) This has the advantage that any results that are not able to be applied remain unplotted on a chart. Hope that helps, Alan. -- The views expressed are my own, and not those of my employer or anyone else associated with me. My current valid email address is: 6f7chu602@sneakemail.com This is valid as is. It is not munged, or altered at all. It will be valid for AT LEAST one month from the date of this post. If you are trying to contact me after that time, it MAY still be valid, but may also have been deactivated due to spam. If so, and you want to contact me by email, try searching for a more recent post by me to find my current email address
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
