|
|
(14 intermediate revisions by one other user not shown) |
Line 1: |
Line 1: |
− | <span id="Variance" />
| + | #REDIRECT [[Business Charts]] |
− | == Absolute Variance ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | style="width:305px" | [[File:MC_Variance.png|thumb|left]] || Displays the variance between two values, often between the budget and actual values.
| |
− | |}
| |
− | | |
− | <span id="VariancePercentLolliplot" />
| |
− | == Relative Variance (%) ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | Displays the relative variance between two values. || style="width:305px" | [[File:MC_VariancePercentLolliplot.png|thumb|left]]
| |
− | |}
| |
− | | |
− | <span id="ValuesWithVarianceOffsetBar" />
| |
− | == Integrated Variance ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | style="width:305px" | [[File:MC_ValuesWithVarianceOffsetBar.png|thumb|left]] || Shows the actual and variance in the same chart with colour indicating the direction of the variance.
| |
− | |}
| |
− | | |
− | <span id="ValuesWithVarianceArrow" />
| |
− | | |
− | == Indicator Comparison ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- 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" />
| |
− | | |
− | == Offset Comparison ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | style="width:305px" | [[File:MC_ValuesCompare.png|thumb|left]] || Shows actual and target values in one chart. The actuals are prominent while the target values can still be referred to.
| |
− | |}
| |
− | | |
− | <span id="ValuesWithForecastTwoColumns" />
| |
− | | |
− | == Business Scenario ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | description || style="width:305px" | [[File:MC_ValuesWithForecastTwoColumns.png|thumb|left]]
| |
− | |}
| |
− | | |
− | <span id="Waterfall" />
| |
− | == Waterfall ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | style="width:305px" | [[File:MC_Waterfall.png|thumb|left]] || description
| |
− | |}
| |
− | | |
− | <span id="WaterfallPeriodComparison" />
| |
− | == Variance Waterfall ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | description || style="width:305px" | [[File:MC_WaterfallPeriodComparison.png|thumb|left]]
| |
− | |}
| |
− | | |
− | ====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.
| |
− | | |
− | <span id="ValuesCompareLines" />
| |
− | == Trend Comparison ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | style="width:305px" | [[File:MC_ValuesCompareLines.png|thumb|left]] || description
| |
− | |}
| |
− | | |
− | <span id="ValuesCompareLinesCumulative" />
| |
− | == Trend Comparison (Cumulative) ==
| |
− | | |
− | {| style="width:100%"
| |
− | |- style="vertical-align:top;"
| |
− | | description || style="width:305px" | [[File:MC_ValuesCompareLinesCumulative.png|thumb|left]]
| |
− | |}
| |