UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> Excel: Null values appearing on graph    
 
   
ian_john_walker
post Jul 10 2006, 06:03 AM
Post #1

UtterAccess Addict
Posts: 270
From: Southampton, UK
Hi guys,

I have a series of data which is plotted on a graph. These figures are actual volumes/projected volumes. There is also a set field which contains the last date of available data (Summary!$P$6).

I have set this up so that there is only ever one figure per day, so that there is either an actual volume, or a projected volume depending on what the last date available is.

I am using the below formula to set any values which are not required (i.e. future actual/past projections) to null (""), however the 0 value still appears on the graph, is there a different way of doing this so they don't show?

=IF(B121>Summary!$P$6,"",SUM($E$5:E121))

Regards

Ian
Go to the top of the page
 
+
Candace Tripp
post Jul 11 2006, 07:50 AM
Post #2

UA Admin & Utter Angel
Posts: 3,039
From: Virginia, USA
Search Help on the NA() function
Go to the top of the page
 
+
ian_john_walker
post Jul 11 2006, 08:25 AM
Post #3

UtterAccess Addict
Posts: 270
From: Southampton, UK
Brilliant, cheers Candice!
Go to the top of the page
 
+
« Next Oldest · Microsoft Excel · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 09:39 PM