Difference between revisions of "Message Charts"
(→Integrated Variance) |
(→Indicator Comparison) |
||
| Line 29: | Line 29: | ||
{| style="width:100%" | {| style="width:100%" | ||
|- style="vertical-align:top;" | |- style="vertical-align:top;" | ||
| − | | | + | | Shows actual and target values in one chart. The arrow position and colour indicate the target value and direction of the variance. || style="width:305px" | [[File:MC_ValuesWithVarianceArrow.png|thumb|left]] |
|} | |} | ||
<span id="ValuesCompare" /> | <span id="ValuesCompare" /> | ||
| + | |||
== Offset Comparison == | == Offset Comparison == | ||
Revision as of 12:16, 10 March 2020
Contents
[hide]Absolute Variance
| Displays the variance between two values, often between the budget and actual values. |
Relative Variance (%)
| Displays the relative variance between two values. |
Integrated Variance
| Shows the actual and variance in the same chart with colour indicating the direction of the variance. |
Indicator Comparison
| Shows actual and target values in one chart. The arrow position and colour indicate the target value and direction of the variance. |
Offset Comparison
| description |
Business Scenario
| description |
Waterfall
| description |
Variance Waterfall
| description |
Outputting cells
If you have split by a different category hierarchy and want to output the category to excel then you can pick a range of two cells to put the values in. The first will contain the date member, the second the split-by member.
Trend Comparison
| description |
Trend Comparison (Cumulative)
| description |
