Add Features to Your Chart

You can add many features to your SAP Analytics Cloud charts, including axis breaks, error bars, or reference lines.

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

  1. In your chart, select one or more outlier measures.
  2. Right-click and then select 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

  1. In your Bubble or Scatterplot chart, select the X or Y axis.
  2. Select (Add axis line break).
  3. Select another axis or another location on the same axis and add another axis line break.
  4. (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.

Procedure

  1. Select an existing bar or column chart.
  2. From the chart action menu (), select Start of the navigation pathAdd Next navigation step Error BarEnd of the navigation path.
  3. Select the Measure for the error bar.
  4. Select the lower and upper error values.
  5. Change the display options.
  6. 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

  1. Select the chart.
  2. From the chart action menu (), select Start of the navigation pathShow/Hide Next navigation step FooterEnd of the navigation path .
    A footer section with the phrase Click to enter text is displayed in the chart.
  3. 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 Start of the navigation path (More Actions) Next navigation step  Add Smart InsightsEnd of the navigation path. The generated dynamic text in the footer corresponds to the first insight available for your data.
  4. (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

  1. 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 Start of the navigation pathAdd Next navigation step Reference LineEnd of the navigation path.

      1. On a canvas or responsive page, select a chart, open the Designer and select Builder.

      2. Find Chart Structure and select Start of the navigation path(Add Chart Components) Next navigation step Add Reference LineEnd of the navigation path.

    • On a grid page, open the Examine panel, select (more), and then select Reference Lines.
    • In the Explorer, select Start of the navigation path Next navigation step Reference LinesEnd of the navigation path.
  2. 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.
  3. 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.
  4. 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.

Adding 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

  1. In your chart, select the title or part of the title.
  2. Right-click and then select Dynamic Text.
  3. In the Insert Dynamic Text dialog, select the check box 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

    		  

    Chart Properties
    You can add various chart properties to the title or subtitle.

    • Measures

    • Dimensions

    • Scales

    • Units
  4. Select Create.

Results

Dynamic text is added to the title.
Related Information