Scaling Charts

In SAP Analytics Cloud, you can scale your charts so that measures have the same scale across multiple charts.

Context

If multiple charts in a story contain the same measure, the measure values may be scaled differently in different charts, which can make comparisons difficult.

Note

  • Chart scaling doesn't force charts to have the same axis range.

    For example, if one chart on a page has negative values but other charts don't, only the one chart will include negative values when scaled, and the 0 coordinates won't be in the same location across all charts.

    To add a negative value range to other charts (for visual alignment), you need to manually edit the axis in those charts.

    For information on editing the chart axis, see Modify Axes on Single or Dual Axis Charts.

  • Chart scaling is applied to all of the pages in a story, but the scaling may be different for the same measure on different pages, because the scaling factor is calculated separately for each page.

  • You can exclude charts from the scaling.

    For example, you may want to exclude a chart that contains data that is much larger than the data in other charts, because it makes the other charts look small.

  • When you have multiple hierarchies in an account dimension, you can only apply scaling to charts that use the default account hierarchy.

Procedure

  1. Open the story that contains the charts you want to scale, and on the toolbar select (Chart Scaling).
  2. Select the measures that you want to scale.
    The affected charts in the story are rescaled automatically, and an axis scaling rule is created.
    Note
    Once a measure is included in an axis scaling rule, that measure can't be included in another axis scaling rule.
  3. To set the bar widths in the scaled charts to a consistent size, hover over the axis scaling rule you just created under Chart Scaling, and select Start of the navigation path Next navigation step Fix Bar WidthEnd of the navigation path.

    Type the number of pixels you'd like to set the bar width to. To revert back to the default widths, delete the number you typed.

    When conflicting bar widths are defined, the width rule of the first measure on the axis is applied to the overall chart.

    When an axis scaling rule is deleted, any associated bar width setting is also deleted, and the bar widths revert to the default sizes.

  4. To exclude a chart from scaling, do the following:
    1. Select the chart, and then select Start of the navigation path More Actions Next navigation step  Edit StylingEnd of the navigation path.
    2. In the Styling panel, expand Chart Properties, and then set Break Scale to On.
  5. To change which measures are scaled, hover over a measure in the Scaled Entities list, and select (Edit Scaling).
  6. To remove scaling for a measure, hover over the measure in the Scaled Entities list, and select (Remove Scaling).