图和NA（） [英] Graphs and NA()

问题描述

早上好！

我有一个令人烦恼的Excel问题，我相信每个人都会知道如何解决（！）

I have one of those annoying Excel issues that I'm sure everyone will know how to solve (!)

我有一个每日更新的数据表，并从中绘制了几个图表。 如果还没有特定日期的数据，我已使用公式指定NA（）的值。 然而，在一组和一组数据中，图表变为零。

I have a data sheet that updates daily and from which several graphs are drawn.  I have used formula to specify a value of NA() if there is no data for a particular day yet.  However on one set, and only one set, of data the graphs go to zero.

我用来生成表格的公式是= IF（（IF（ISNA（A2） ，0，A2）* $ A $ 1 + IF（ISNA（D2），0，D2）* $ d $ 1）= 0，NA（），（IF（ISNA（A2），0，A2）* $ A $ 1 + IF（ISNA（D2），0，D2）* $ D $ 1（删除了一些术语，但希望它有意义） 这个公式看看
所有其他单元格（也用于创建图形）是否具有其中包含NA（），如果是，则返回NA（），否则返回一个值。

The formula I use to generate the table is =IF((IF(ISNA(A2),0,A2)*$A$1+IF(ISNA(D2),0,D2)*$D$1)=0,NA(),(IF(ISNA(A2),0,A2)*$A$1+IF(ISNA(D2),0,D2)*$D$1 (A few terms removed, but hopefully it makes sense)  This formula looks to see if all other cells (also used to create graphs) have NA() in them, if so then it returns NA(), else it returns a value.

我想发布数据表和图表的图像，以使其更清晰但论坛不允许我这样做....

I would like to post images of the data table and the graph to make it clearer but the forum won't allow me to do so....

推荐答案

>> >我想发布数据表和图表的图像以使其更清晰但论坛不允许我这样做....



根据您的描述，您可以参考如何验证您的MSDN / TechNet论坛帐户，以便您可以发布图像和链接



https://social .technet.microsoft.com /维基/内容/文章/ 15960.how到验证 - 您 - msdntechnet的论坛账户那么该吃到-后的图像和-links.aspx



此外，这是讨论开发Office 2013应用程序的问题和反馈的论坛，似乎这个问题与代码无关，但与Excel公式有关，所以我建议您可以将您的问题发布到Technet论坛上，以便进行Excel
IT专业人员讨论。


https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel



我们建议适当发布的原因是，您将获得最合格的受访者群体， 

和其他合作伙伴阅读论坛定期可以分享他们的知识或者从您与我们的互动中学习。 
$


感谢您的理解。

>>>I would like to post images of the data table and the graph to make it clearer but the forum won't allow me to do so....

According to your description, you could refer to How to Verify Your MSDN/TechNet Forums Account So that You Can Post Images and Links

https://social.technet.microsoft.com/wiki/contents/articles/15960.how-to-verify-your-msdntechnet-forums-account-so-that-you-can-post-images-and-links.aspx

In addition this is the forum to discuss questions and feedback for Developing Apps for Office 2013, it seems that this issue is not related to code, but related to Excel formula, so I suggest that you could post your question to the Technet forum for Excel IT Pro Discussions

https://social.technet.microsoft.com/Forums/office/en-US/home?forum=excel

The reason why we recommend posting appropriately is you will get the most qualified pool of respondents, 
and other partners who read the forums regularly can either share their knowledge or learn from your interaction with us. 

Thanks for your understanding.

这篇关于图和NA（）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！