|
|
| (15 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]] || description
| |
| − | |}
| |
| − | | |
| − | <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]]
| |
| − | |}
| |
