If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
blank cell interpolation problems
On Tue, 21 Oct 2003 21:22:55 -0400, Jacobs =
wrote: I am trying to plot a data set with a conditional. Here are a few of = my attempts : =3DIF(O111=3D0, NA(),IF(O1116,O111,NA())) or =3DIF(O111=3D0, #N/A),IF(O1116,O111,#N/A)) even =3DIF(O15=3D0, "",IF(O156,O15, "")) *this one doesn't even plot *my= * x values, just some incrementally increasing crap* I want the chart to plot only the values that have data in them as a line plot. So you would see gaps in the line where there is no data. I can't get it to work. I have read all the other posts about this similar topic but I can't seem to get it right. I have my tried formatted the cells as numbers and as general. I have tried setting the chart options to 'not plotted (leave gaps)'. The problem is that excel is interpolating between the cells that have values in them and not leaving gaps in the plot. Each plot starts with the first actual value. So, if my data starts with 100 blanks spaces the plot will start at the 101 piece of actual data, nut then it will interpolate through any other blanks. Probably because it has nothing above it (the 100 blanks) to interpolate with. I am using excel2002. Please let me know if you need more info or I am being vague. Your help will be appreciated. Try www.tushar-mehta.com, look for "Chart gap for N/A" on the left. = Perhaps that will help. -- = Dave dvt at psu dot edu |
#2
|
|||
|
|||
blank cell interpolation problems
You need to post the context of your reply as I did by including your
message. You may also want to connect to the Usenet newsgroups directly. For more, see the 'Outlook Express and Newsgroups' tutorial on my web site. Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article , says... I haven't tried it yet but it looks like it is exactly what I need. Thanks for your help Dave! You da man ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~ View and post usenet messages directly from http://www.ExcelForum.com/ |
#3
|
|||
|
|||
blank cell interpolation problems
Tushar Mehta wrote: *You need to post the context of your reply as I did by including your message. You may also want to connect to the Usenet newsgroups directly. For more, see the 'Outlook Express and Newsgroups' tutorial on my web site. Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions * Tushar, do you think you can tell me why I can't get the addin to work? I think I am doing it right but maybe not. I am just plotting one series of data as a line plot. I tried to do a simple example like the one on your page with =na() every now and then, but I couldn't get it to work. I really appreciate your help with this matter, because it it really important that I figure out a way to do this. Also, your webpage is great. You help a lot of people out and I think that's pretty damn cool. ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ |
Thread Tools | |
Display Modes | |
|
|