Message Charts

Revision as of 12:17, 10 March 2020 by Colin (talk | contribs) (Offset Comparison)

Absolute Variance

MC Variance.png
Displays the variance between two values, often between the budget and actual values.

Relative Variance (%)

Displays the relative variance between two values.
MC VariancePercentLolliplot.png

Integrated Variance

MC ValuesWithVarianceOffsetBar.png
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.
MC ValuesWithVarianceArrow.png

Offset Comparison

MC ValuesCompare.png
Shows actual and target values in one chart. The actuals are prominent while the target values can still be referred to.

Business Scenario

description
MC ValuesWithForecastTwoColumns.png

Waterfall

MC Waterfall.png
description

Variance Waterfall

description
MC WaterfallPeriodComparison.png

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

MC ValuesCompareLines.png
description

Trend Comparison (Cumulative)

description
MC ValuesCompareLinesCumulative.png