寻找某种帮助,或在正确方向指出。 我甚至不知道哪里开始。 我相信存在解决办法,但我的大脑不会看到。
To use as an example I have a table that shows monthly results for multiple different areas:
我想做的是,在每一数字的边际差距中,每个数字都显示,使用arrow缩的箭和广场,会增加、减少或改变。 我可以采用有条件的方式来处理这个问题,因为我也希望它成为多种颜色。 因此,它将考虑到增加和减少以及是否达到目标。 见下文:
。
我每月都会复制和复制。 但是,使其自动化将是令人吃惊的。 希望这一结果能够看上去:。
我希望,我能与上个月做两件事,然后对照我的表格检查,看看一下哪儿会展示适当的象征。
事先感谢你提供的任何帮助或启动的地点。
在我以简单易懂的方式看待这一问题之后,就很容易得出。
首先,我使用的是=IF(-Sign(E26-G26)=0,“n”,红十字与红新月(E26-G26)=1,“é”,红十字与红新月(E26-G26)=-1,“pro”))。
将现有数字与前一个数字进行比较,并视数字下降或保持不变而获得1,0或-1,同时使用该数字显示经济、社会或社会。 然后,我把这些囚室带上ont锁。 因此,他们变成了arrow、 down和广场。
然后,我使用有条件格式,根据邻近的囚室价值加以颜色。
不需要长期复杂的公式
= IF(A2>A1,“t”,IF(A2<A1,“u”,”v) - 设定字体为Marlett
Is there any ariticles or suggestions that can help me go through this: How to programmatically create/build Sharepoint PPS -- Dashboard, Scorecard, KPIs, and then dploy it or import it to a web page? ...
[ short reminder: english is not my native language :) ] Hello, I have this problem for a few days now (and it starts to drive me seriously mad). Like the title says, my problem is that I need to ...
I have a table with monthly summary of KPIs. The customer now wants to be able to make adjustments to the original data. I have to allow for adjustments as well as preserving the original data. The ...
I m a development manager for a medium sized company. I ve never had specific KPI s before and now I am being given some. The KPIs I ve been given I don t think relate too well to my role. I would ...
I want to be able to create a KPI List on my MOSS 2007 installation via the object model. Is this possible?
I m going to lead a new User Experience Team and I m struggling with the definition of KPI for the team. My question is non-technical and I m asking after what KPI s I should measure.
[SharePoint/MOSS 2007] I want to access several web services (on external sites, with WSDL descriptors), and graphically display the data, using a separate web part to display each item. The graph ...
I am working on improving website performance. Here are the list of key performance indicators I am looking at for each page Total Bytes downloaded Number of requests DNS look up time FirstByte ...
