Symptom
In a Combination Column (or Stacked Column) & Line Chart, the column and line do not sync scale when the axis Minimum/Maximum is set to Auto in SAP Analytics Cloud (SAC).
Environment
SAP Analytics Cloud.
Reproducing the Issue
- Create a Story in SAP Analytics Cloud.
- Insert a Combination Column (or Stacked Column) & Line Chart.
- Leave the axis Minimum and Maximum set to Auto.
>>Observe that the Column axis and the Line axis are not synchronized in scale.
Cause
Use of the Chart Scaling feature is required to synchronize bar and line scaling.
Resolution
- To set "Chart Scaling" on a chart in SAP Analytics Cloud in classic design mode:
-
- Clear any setting that could prevent Chart Scaling from applying:
- 1.1 Select the chart and click the "Edit Axis" button on the action menu
- 1.2 Reset all the axes ranges to “auto” button on the action menu
- 1.3 Turn off the “Dynamically scale min/max” toggle if it is on and visible
- 1.4 Select the chart and click "Styling" in the Designer side panel
- 1.5 Turn off the “Break Scale” toggle if it is on and visible
- Enable Chart Scaling
- 2.1 Scale the desired Chart axes together by clicking the "Chart Scaling" icon.
- 2.2 Select the measure(s) in the chart to have them scale together.
- Clear any setting that could prevent Chart Scaling from applying:
- Note:
- Chart-Scaling is not applied in Full-screen mode, and Explorer View mode.
- For reference, and more details, see the KBA: 2877916 - Scaling in full screen mode in SAP Analytics Cloud (SAC)
- One other option is to switch to Optimized Design Mode and use the Synchronize Axis in a Dual-Axis chart feature (See help documentation here)
Keywords
EPM, SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, combination, column, line, chart, axis, data, label, minimum, maximum, auto, min, max , KBA , LOD-ANA , SAP Analytics Cloud (SAC) , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , LOD-ANA-PL , Planning , LOD-ANA-BR , SAC Boardroom , LOD-ANA-PR , SAC Predictive , How To
SAP Knowledge Base Article - Public