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?
Resolution
- 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.
- 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.
- Repeat the step for the new values
- 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.
- Repeat the step for the new values
- 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.
- Create two Bar charts, one for original value and another for the new column
- In Bar Chart Behavior/Scale tab set Manual(x) Axis and add cells as Minimum and Maximum calculated above
- On the same tab specify the number of Divisions
- In the original Bar chart Appearance/Text tab suppress the Horizontal (Value) Axis Labels
- 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 , Obsolete: BusinessObjects Dashboards and Presentation Design , How To
Product
SAP BusinessObjects Dashboards 3.0
Attachments
Sample2.xlf |