Add Features to Your Chart

Add Axis Breaks to Bar or Waterfall Charts

Context

When a chart has one or two bars that are significantly longer than the rest, the chart can be difficult to read. An axis break lets you shrink the longer bars and improve readability of the shorter ones.

Axis breaks can be added to the following chart types:

Bar/Column
Waterfall

Note

Axis break may not be available when the axis range is manually set.

If you set an axis break and then edit the axis range, the axis break may be removed.
Selection is retained for drill-states.
You can have only one axis break in a chart.

Procedure

In your chart, select one or more outlier measures.
Right-click and then select Break Axis.

Tip

To see the option, you may need to right-click and then select More Options Break Axis

Results

An axis break is added to the chart. To remove it, select a measure and then click

Disable axis break.

Add Axis Line Breaks to Bubble or Scatterplot Charts

Context

When a chart has widely spread bubbles or clusters of datapoints, it can be difficult to read. Axis line breaks help reduce the visual gap in the data, improving the readability. You can apply and edit multiple axis line breaks on both axes.

Procedure

Select an axis.
Select (Add axis line break).
Select another axis or another location on the same axis and add another axis line break.
(Optional) To change the range covered by the axis break, select an axis line break and select (Edit axis line break).

Add an Error Bar to a Chart

Context

Error bars can be added to bar/column charts. They can provide a general idea of how precise a measurement is or how far the reported value is from the error-free value.In your Bubble or Scatterplot chart, select the X or Y axis.

Procedure

Select an existing bar or column chart.
From the chart action menu (), select Add Error Bar.
Select the Measure for the error bar.
Select the lower and upper error values.
Change the display options.
When finished, select OK.

Results

An error bar is added to your chart.

Add a Footer to a Chart

Context

You can add a line or block of text appearing at the foot of a chart widget in your story.

The footer will not be available in the following scenarios:

Viewing the chart in Explorer.
Viewing the chart as a pinned item on your home screen.

Procedure

Select the chart.
From the chart action menu (), select Show/Hide Footer .

A footer section with the phrase Click to enter text is displayed in the chart.

Tip

If you don't see the footer option, in the action menu select More Options Show/Hide Footer.
Replace the default text with your footer text.

Tip
You can add Smart Insight tokens that display dynamic text to chart footers. From your chart, choose (More Actions) Add Smart Insights. The generated dynamic text in the footer corresponds to the first insight available for your data.
(Optional) Change the styling of the footer text.
Open the Designer panel and select (Styling). Apply any of the following styling options to the text:
- Text Properties:
  - Select the font style, size, and color.
  - Select the paragraph justification.
  - Add bulleted or numbered lists to text.
- Hyperlink: Link to another story or page, or to an external URL.

Add a Reference Line

Context

You can define reference lines to show important values on your chart; for example, the average and maximum prices of your company's products.

There are two types of reference lines: fixed and dynamic.

Fixed reference lines are created with a specific reference value, and don't change when you change the data in your chart (for example, if you filter your data).
Dynamic reference lines are updated when filters, ranking, and sorting are applied to the chart. Dynamic reference lines can be used with any measure, including story calculation measures.

When you add a reference line, you can choose to fill the background area above and below the line with color. Reference lines are maintained when you change the chart type.

Procedure

Add a reference line in one of these ways:
- On a canvas or responsive page, select a chart, right-click or select and then select Add Reference Line.
  
  Tip
  
  If you don't see the reference line option, in the menu select More Options Add Reference Line.
- 1. On a canvas or responsive page, select a chart, open the Designer and select Builder.
  2. Find Chart Structure and select (Add/Remove Chart Components) Add Reference Line.
- On a grid page, open the Examine panel, select (more), and then select Reference Lines.
- In the Explorer, select Reference Lines.
Choose whether you want a fixed or dynamic reference line.
- For a fixed reference line, enter a value and a label for the line.
- For a dynamic reference line, select the parameters you want to base the reference line on, and enter a label for the line.
If you want to color the background areas above and below (or to the left and right of) the reference line, choose colors in the Above and Below color-pickers.
If two reference lines try to set the same background area to different colors, the line created first takes precedence.
If you have applied a Top N filter to the chart, and are adding a dynamic reference line, you can choose whether you want to include the Top N options as a filter for the reference line.
For example, if you're adding a dynamic reference line with average aggregation, and you have a Top 5 ranking applied, you can choose whether the reference line averages all values or only the Top 5 values.

Results

Select OK to add the reference line to the chart. You can hover over the reference line to see details about the line.

Add a Compound Annual Growth Rate Line to Bar or Stacked Charts

Show the Compound Annual Growth Rate for SAP Analytics Cloud Bar/Column or Stacked charts.

Prerequisites

The chart must meet the following requirements:

The chart must have a Date dimension on an axis.
The time period that is used must be higher than week (for example, month, quarter, or year).
There need to be at least two positive data points in the selected time period.

Note

This feature is not yet available for SAP BW Live models.

Context

The Compound Annual Growth Rate (CAGR) is the ratio that provides a constant rate of return over the time period. You can add a CAGR line to your Bar/Column or Stacked Bar/Column chart.

Procedure

Select your chart.
From the chart action menu (), select Add CGR.

Tip

If you don't see the CGR option, in the menu select More Options Add Add CGR.

Results

A CAGR line is added to your chart. If you have changed the drill level for other dimensions, you may see separate CAGR lines instead of a continuous one.

Dynamically Add a Time Calculation

You can add one or more time calculations to your chart without using the calculation editor.

Prerequisites

Your chart must contain a date dimension with the appropriate level of granularity. For example, if you want to see quarter over quarter results, the date dimension must include quarterly or even monthly results.

Context

You can add a time calculation to a chart to show year over year changes in quantity sold.

Procedure

Add a measure and a date dimension to your chart.
In the Builder, find the measure that you added.
Select More Add Time Calculation, and then select a time period.

Results

A new measure is created. The chart now includes a bar for the time calculation.

Note

When using acquired models created with SAP Analytics Cloud version 2021.02 or later, dynamic time calculations and variances should display data when the page and story filters are applied on the time dimensions. If you are experiencing issues with the displayed data please refer to 2994816 Information published on SAP site

.

Annotate Data Points in Bar, Line, or Bubble Charts

You can annotate data points in Bar, Line, and Bubble charts.

Context

You can pin a data point and add additional measures or comments to the pinned object. The pinned information is displayed as a Numeric point chart that is linked to the data point.

Note

You can annotate data points on Canvas pages only.

If you filter the data, the annotated chart will not be affected. However, if you add another measure to your chart, you will break the link.

Procedure

In your chart, select a data point.
Right-click and then select Pin Data Point.

A numeric point chart appears. It is anchored to the data point.
In the numeric point chart, add footer text or other comments.
With the numeric point chart selected, open (Builder) and choose measures to add to the annotation.

You cannot edit existing measures, but you can add more measures.

Add Dynamic Text to a Chart Title

In SAP Analytics Cloud, you can add dynamic text to a chart title or subtitle.

Context

You can change the title of a chart to include dynamic text from elements that are in use in the chart, such as filters, dimensions, scales, and so on.

Procedure

In your chart, select the title or part of the title.
Right-click and then select Dynamic Text.

In the Insert Dynamic Text dialog, select the checkbox for the object you want to use as the source for your dynamic text.

You can scroll through all the options, or select an option from the left side to display specific objects on the right.

Option	Objects
Story Properties	Current User Current Time Current Date Last Modified Date Last Modified Date/Time Last Modifier (last person to modify the story) Creator Page Number
Dimensions	For dimensions, you can also specify which hierarchy and level to display, and whether to display the ID or description.
Input Controls
Calculation Input Controls
Measure Input Controls
Dimension Input Controls
Story Filters
Tile Filters & Variables	Tile (or widget) filters and variables include the filters and variables that are used in charts and tables. Note The tile filters and variables will not appear on mobile devices.
Model Variables
Model Properties (Optimized Story Experience)	Last Refreshed Date and Time: You can add last refreshed data and time of any SAP BW live data model used in your story.
Chart Properties	You can add various chart properties to the title or subtitle. Measures Dimensions Scales Units
Team Signature	Use the team signature to identify who is authorized to modify the story. Note When the story is modified by someone who isn't a member of the team, a warning message is displayed instead of the team name through a dynamic text that puts a mark in the story as a trust factor.
Script Variables (Optimized Story Experience)	Note Only variables of string, number or integer types can be used. Variables set as array aren't supported. Note In view time, the global variables will change according to the customized scripts, and their values will be automatically updated in the text widget.

Select Create.

Results

Dynamic text is added to the title.