Configuring Charts

After completing this lesson, you will be able to:

After completing this lesson, you will be able to:

  • Build and format charts


Create charts in a story to display your data graphically. As shown in the figure Introduction to SAP Analytics Cloud Charts you can select a chart type from the builder and then pick the measures and dimensions to show in your chart. Once you have defined the structure of your chart, you can add reference lines or filters to it. You can also customize color palettes.

You can choose from many different types of charts.

Chart Scaling

Chart scaling ensures that you have a meaningful display of values across multiple charts. Watch this video to learn how you can scale 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, if a chart contains data that is much larger than the data in other charts, the other charts look smaller than they should and could be misleading to the viewer.

Variances in Charts

Variances in your charts let you show the difference between different measures in a chart, different versions of a measure, or the difference between time periods for a measure.

As illustrated in the figure Example of a Chart with a Variance, you can use the variance chart add-on for any two measures, even if the measures do not appear in your base chart. You can create variances that do not include the versions for the measures, as well as variances that do include time periods.

You can also create a dynamic variance, a variance that is based on the measures in the chart context. If you change the measures in the chart, the variance automatically updates.


To include time in your variance, you must have the Date dimension in your chart.

For some chart types (numeric point, for example), when the variance uses a Time Range filter, the range must be set to only one interval (year, quarter, or period).

When using models from live data connections, you must include version information with your measures, and your measures must be in your base chart.

Trellis Add-On

A trellis add-on creates the same chart for the members of the trellis dimension.

Trellis charts are supported for both classic and optimized stories.

Configure Charts

Task 1: Configure charts in a story

Business example

You are responsible for creating visualizations to meet a variety of business requirements for you team.

You need learn how to configure charts and work with chart features that the users will find helpful.

Task flow

In this practice exercise, you will perform the following tasks:

  • Add a reference line
  • Add a variance
  • Add a trellis
  • Add a tool tip
  • Use chart scaling
  • Format pages
  • Format charts and data labels

Deleted Widget Restoration

If you delete a widget in your story, you can restore it, but how you restore it depends on which design mode you are using – Optimized Design or Classic Design.

Optimized Design

To restore a widget you have deleted, use the Undo button in the main toolbar. Undo reverts any previous action, from adding/deleting widgets to configuring them.

Classic Design

To restore a widget you have deleted, you must immediately choose the Restore link in the message at the bottom of the screen:

This message appears for only a few seconds and then disappears. Once it disappears, you can no longer restore your deleted widget.

Save progress to your learning plan by logging in or creating an account

Login or Register