#### Question #3

```Hi

I have some data that I graph.

Column A has a date [has data in 12 rows]
Column B has a data entry (number) [has data in 1st 6 rows]
Column C has a data entry (number) [has data in 1 st 6 rows]
Column D has a formula that calculates a % on column B & C [formulas in 12
rows]

The graph range I have covers the whole 12 rows but it seems to read the
formulas in col D and plots every row

Is there something I can add to my formula that stops the graph from
plotting it unless there has been an answer returned in it?

Formula I have is : =IF(B5+C5<1,"",(B5-C5)/B5)

Thanks

John
```
 0
JohnCalder (178)
11/24/2006 12:30:01 AM
excel.newusers 15348 articles. 2 followers.

1 Replies
441 Views

Similar Articles

[PageSpeed] 28

```Try

=IF(B5+C5<1,NA(),(B5-C5)/B5)

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"John Calder" <JohnCalder@discussions.microsoft.com> wrote in message
news:32407A07-5158-453D-A032-5E7052F03EEE@microsoft.com...
> Hi
>
> I have some data that I graph.
>
> Column A has a date [has data in 12 rows]
> Column B has a data entry (number) [has data in 1st 6 rows]
> Column C has a data entry (number) [has data in 1 st 6 rows]
> Column D has a formula that calculates a % on column B & C [formulas in 12
> rows]
>
> The graph range I have covers the whole 12 rows but it seems to read the
> formulas in col D and plots every row
>
> Is there something I can add to my formula that stops the graph from
> plotting it unless there has been an answer returned in it?
>
> Formula I have is : =IF(B5+C5<1,"",(B5-C5)/B5)
>
> Thanks
>
> John

```
 0
bob.NGs (282)
11/24/2006 9:00:07 AM
 Reply:

Similar Artilces:

Sample CRM 3.0 reports downloadable from Partnersource
It would be useful to have sample reports from CRM 3.0 availble to download from Partnersource to show customers what the reports look like. Customers won't have enough data in their own CRM for some time after going live, therefore they cannot easily get an idea of what information the standard reports in CRM can provide. This would be useful to Partners to use as a selling aid and in giving training. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" ...

CRM 3.0
Hi All, I am writing a custom report for CRM 3.0 to basically copy the My Activities view but display the regarding and To contacts and associated phone numbers. The report is basically done except for a few small issues. I would like to set up the Dynamic Drill-Through so when the person clicks on the Activity Subject it will open the associated Activity record. Unfortunately I have been unable to find the information needed to use in the following code to set the Object Type Code (OTC) to the correct activity type: = Parameters!CRM_URL.Value & "?ID={"&Fields!Activityid...

MFC and threads #3
Greetings, I am running into a problem when trying to pause a thread in MFC based application. This is my first time using user defined Events for synchronization. The scenario is like this. Code executes in a worker thread and based on some conditions thread launches another new dialog window. That window displays some message to user ie, Hello There! in an Edit control. I provide a Resume button on the bottom of that message Window so that user can continue after reading the message and the worker thread should continue from where it left off. This is the code for that Resume button. v...

Optimiztion question
I was looking at MSDN on optimizing queries (http://msdn.microsoft.com/en-us/library/ms998577.aspx) and am unclear as to why a foreign key relationship affects the query in this case. At the beginning of the article it gives an example and starts out by saying: The sample screen shot in Figure 14.2 shows an execution plan that accesses only one table, although two tables are included in a join in the query. Because there is a declared foreign key relationship between the authors table and the titleauthor table, and the au_id column in the titleauthor table is not allowed to b...

Send #3
Messages waiting to be sent are NOT formatted in italic in the Outbox, and therefore remain in the outbox after send/receive. Hi - please tell us your version of Outlook, what service pack you have, what mode if applicable (see all this in help | about) and what kind of e-mail account you use. Bernie wrote: > Messages waiting to be sent are NOT formatted in italic in > the Outbox, and therefore remain in the outbox after > send/receive. ...

Create Expression from Func? (3.5 SP1)
Hello: Is there are way to create an Expression from a Func? I don't like cluttering up my method signatures with the whole Expression<Func<TResult, T>> type. I would prefer for callers to simply see Func<TResult, T> instead. I'd like to take a Func and create an Expression from it. Is that possible? Thanks, Travis Parks Jehu Galeahsa wrote: > Hello: > > Is there are way to create an Expression from a Func? I don't like > cluttering up my method signatures with the whole > Expression<Func<TResult, T>> type. I would ...

photogallery in pub #3
How many default photos in photo gallery web page of publishers? Ans is 12 but please explain any body. Thanks in advance. ...

Calendar sharing #3
Hello all, the current exchange setup is as follows: 1. domain A.... is windows 2000, with exchange 5.5 and is hosted in Organization A 2. domain B .... is windows 2003, with exchange 2003 and is hosted in Organization B Is there a way for users from both domains to access the other's calendar ( for example, user 1 in domain A wants to access user 2 in domain B)? Any input is appreciated. Thanks. Diana Hi Diana, You may consider the InterOrg Replication Utility to accomplish this. Read more about it here: http://www.microsoft.com/downloads/details.aspx?FamilyId=E7A951D7-155...

Access 97 Runtime question
We are using Access 97 runtime for some of our staff. I noticed today that in reports if they right mouse click, they don't get a shortcut menu. I want them to be able to Export the report they are viewing. Would Access 2003 runtime have the shortcut menu? Thanks Kelvin "Kelvin Beaton" <kelvin dot beaton at mccsa dot c o m> wrote in message news:uiQA0i7zHHA.1168@TK2MSFTNGP02.phx.gbl... > We are using Access 97 runtime for some of our staff. > I noticed today that in reports if they right mouse click, they don't get > a shortcut menu. I want them to be...

Multiple accounts #3
I have 2 Hotmail and 1 MSN accounts set up in Outlook 2002. It shows that it sends and receives all 3 accounts successfully, but when I go to the Inbox of the Hotmail accounts, there aren't any messages. Thanks, Rick It says it send and received fine, but problems occur when you set up more than one HTTP account, so it is recommended that you only use one per profile ...

vlookup help #3
hello, I cant figure out the proper syntax for the attached workbook. Th first 8 options on worksheet two work perfectly ( ie when checked, the appear on worksheet 3) I dont know how to apply the formula of th first 8 options to the rest of the checkboxes. Can someone please help me figure out how to do this? Thanks i advance. Aladdi Attachment filename: start order2.zip Download attachment: http://www.excelforum.com/attachment.php?postid=46674 -- Message posted from http://www.ExcelForum.com Right-click on the sheet tab for the Options worksheet. Select View ...

Macros/Signatures Question
I have an Excel Workbook that I created for a PC Order Form. I set it up to only make certain rows visible based on the Machine Model that they choose. I digital signed the Worksheets and exported the Digital Signature Certificate and installed it on the User’s PCs. The code works great. The user opens the Workbook and it runs the Macros with no problem. The problem I have is when the user goes to save the Workbook. They get an error that “Excel can not sign VBA macros when saving to this file format. Do you want to remove the digital signature and continue saving this workbook?”...

Login problem to CRM 3.0
Hi, I installed CRM 3.0 Professional Edition without any error. I can login perfectly from the CRM server either using http://localhost:5555/ or http://appserver:5555/ under the crmadmin user. If I login to an XP workstation with the same user (crmadmin) and specify http://appserver:5555/ in IE6, I got a login window - where I enter the correct DOMAINNAME\crmadmin username and password - and got the following message: "You are not authorized to view this page"..."HTTP Error 401.1 - Unauthorized... I think the prolem is around IIS security, but what shoud be the next step. Th...

Invest \$3.70 & Earn \$ 1 million By E-gold
Invest \$3.70 and earn \$1,000,000.00 By e-gold! Free sign-up. Guaranteed earnings! http://www.ptsu.biz/index.php?ref=petertian ...

Simple IMAP question
Hi, How do I enable shared calendar with free/busy information through IMAP ? When I add the "calendar" folder in IMAP it displays as a mail folder, not a calendar. Pierrot Is this calendar a mailbox or public folder? Why are you using IMAP instead of MAPI? MAPI is much more feature complete as it applies to this sort of thing. -- Ed Crowley MVP - Exchange "Protecting the world from PSTs and brick backups!" "Pierrot Robert" <mcthepro@nospam.hotmail.com> wrote in message news:%23NzXwrV6GHA.4352@TK2MSFTNGP05.phx.gbl... > Hi, > > How do I...

Exchange 2003 Question??
Dear all, I would like to know if there is an upgrade path from Exchange 2003 Standard Edition with SA to Exchange 2003 Enterprise Edition with SA? Thank you. Regards, Kueh. This might help http://support.microsoft.com/default.aspx?scid=kb;en-us;170280 -- Santhosh Sivarajan MCSE(W2K/NT4),MCSA(W2K3/W2K/MSG),CCNA,Network+ "KA Kueh" <kka@ksm.com.my> wrote in message news:exVKwgOKEHA.1040@TK2MSFTNGP10.phx.gbl... > Dear all, > > I would like to know if there is an upgrade path from Exchange 2003 Standard > Edition with SA to Exchange 2003 Enterprise Edition wit...

Macro Question #10
Hi, I am working with a text file that I imported into Excel. It is a transactional report of sales by customer. The data will have the customer number and name spread out over three cells. What I want to do is to create a macro that will contatenate all three cell and then perform a paste special and paste them into another cell in another column. Since the number of transactions by customer can vary the customer name and number can appear anywhere on the page. I created a macro to do this using the first customer which appears in cell B5 through D5. The next customer appears...

question about leaving messages on server
My husband and I have 1 POP mail account. I am accessing it from a computer in Virginia, where I'm staying with relatives. He is accessing the same account from California. I have my Outlook set up to keep messages on the server, but to delete them after 1 day (so that he will still get the messages, but the server won't get clogged). His email program, Eudora, is set up so the messages will be deleted from the server after he downloads them. Is there a chance I won't get some messages because he has his computer set up that way? (He downloads it 1st, then it gets deleted off serv...

Filtering question
Is there a way to expand the filter option so that it shows 1 row (or more), both above and below any row that contains the value I am looking for? Data|filter|autofilter examines each cell/row on its own. Maybe you can put the key value for each group on the rows you want. Then filter by that column. richzip wrote: > > Is there a way to expand the filter option so that it shows 1 row (or more), > both above and below any row that contains the value I am looking for? -- Dave Peterson ...

Questions on migration from VS2005 to VS2010
Hi folks, As is the case every couple of years, I go through a nerve-wracking transition to a new development environment. The thing is, I've become really comfortable with VS2005, and our small team has a very simple and effective approach to development. I am nervous that VS2010 will negatively effect our productivity; but don't want to get too "far behind" toolset versions. So, that being said, I wanted to ask a few questions on what to expect when moving from VS2005 to VS2010 on an upcoming project. Your feedback is highly appreciated. Question...

New to Money 2006
I was using Money 2004 and upgraded it to 2006 last night (God only knows, why :)). I started to hate the idea of Passport and Web Publishing my account details and so did not choose the Passport option. I was able to install with regular Money stand alone password and still update all my accounts by downloading them from the respective financial institutions (as I used to do with 2004). The problem is with MBNA America. I want to download the credit card transactions. But the online setup process is asking me for passport setup. I looked at the description of this bank on Microsoft site...

upload form problem / server question
www.icingpictures.co.uk / win xp / frontpage 2003 Want to create a form with upload file form field - i read on this forum that the server type i use is important - it should be a windows type server with frontpage extensions - i currently use a linux server with front page extensions - do i need to change to a windows server? Thanks for taking a looka t my question. Joyce Yes, you must have a Windows Server, just like you stated you read. -- Tom [Pepper] Willett Microsoft MVP - FrontPage Since 1997 --------------------------- "threademporium" <threademporiu...

Crm 3.0 11-09-07
I have one server windows 2003 standard r2 sp2 With: _Crm 3.0 _Wsus 3.0 I first installed CRM 3.0 (databases point on another server) and after I installed Wsus 3.0 with standard installation (comprehensive SQL 2005 espress edition) Now when I go to http://nameserver:5555 all open correctly but not report folder. When I click report folder I have an error (there is an error please contact your system administrator). I try to go to http://nameserver/serverreports but there isn't a web page (IIS say impossible find page). Have Wsus delete iis report configuration? How I can restore t...

Outlook Newsgroups #3
Question? Why has Outlook (not Express) always asked in the past if it would like to be the Default News Reader, I believe it has never been able to do this function. Why is it that you have to go to a lower type email program to read Newsgroups? I will never use Express and would love to remove it from my system. I currenty use Mozilla Thunderbird to read Newsgroups. Does anyone know why Micrsoft refuses to add Newsgroup options to their full Outlook program? Thanks >-----Original Message----- >Question? >Why has Outlook (not Express) always asked in the past if it would like...

Outlook 2003 question #4
Hi ... I have 4 email accounts with outlook 2003 and they are all from the same isp provider ... My problem is when i am going to create an email to someone i can't tell which email account is sending the email to , its usually set a default ... What i mean is that when i view my email accounts they are listed as so and so default , # 1 , # 2 , # 3 , I don't know what 1 or 2 or 3 are ... Is there a way to notice which email account is which beside having numbers beside them ... I can't tell which is which ... It would be better if you could view the actual name of the ema...