Using Different Scaling in Base Chart and Deviation

Owned by Tim Schauder
Last updated: Sept 13, 2016

This article describes how to define a manual scaling for the deviation chart and an automatic scaling for the base chart.

This requirement can’t be solved within a single chart. In a chart you can either define the scaling automatically or manually but you can’t define the absolute values to automatic scaling and the percent values to manual scaling. To meet this requirement you have to work with two charts.

Step-by-Step-Guide

  1. Define one chart which shows the base chart without percent values. Define scale mode “automatic” in the corresponding property.


  2. Define another chart which doesn’t show the base chart but the percent deviations. Define scale mode to be “manual”, manual scale percent min to be “-100” and set manual scale percent max to “100” in the corresponding properties.


  3. Deactivate the category labels in Chart 2 (additional properties -> data -> category labels).


  4. Layer the charts as required (in the picture below chart 2 is arranged above chart 1). The percent values are now visualized in the range -100 – 100, absolute values are visualized in an automatic range, depending on the values delivered by the underlying DataSource.