1494420 - How to change base for Y axis in Xcelsius 2008 bar chart

SAP Knowledge Base Article - Public

1494420 - How to change base for Y axis in Xcelsius 2008 bar chart

Symptom

Bar chart in Xcelsius has "0" as a base for vertical line by default.

How to change the base to "1" so the chart will look like the one below?

BarChartBase1.GIF

Resolution

  1. Create an additional column in Excel to calculate a new value like D1=C1-1. Where D1 cell has a new value, C1 has original value, 1 is a value for a new base.
  2. Add Minimum scale limit calculation to the Excel file as following C9=FLOOR(MIN(C1:C7), 1). Where C1:C7 is a range of original values.
  3. Repeat the step for the new values
  4. Add Maximum scale limit calculation to the Excel file as following C10=CEILING(MAX(C1:C7),1). Where C1:C7 is a range of original values.
  5. Repeat the step for the new values
  6. Add a cell to calculate number of Diviions in X scale like following: C11=(C10-C9)*5. Where C10 is maximum and C9 is minimum value.
  7. Create two Bar charts, one for original value and another for the new column
  8. In Bar Chart Behavior/Scale tab set Manual(x) Axis and add cells as Minimum and Maximum calculated above
  9. On the same tab specify the number of Divisions  
  10. In the original Bar chart Appearance/Text tab suppress the Horizontal (Value) Axis Labels
  11. Place the original Bar Chart on the top of the new Bar chart so the only X axis would be visible

See attached .xlf sample file for details.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , How To

Product

SAP BusinessObjects Dashboards 3.0

Attachments

Sample2.xlf