SAP Knowledge Base Article - Public

1543717 - Column chart label formatting is lost in Xcelsius 2008.

Symptom

Column chart label formatting is lost in Xcelsius 2008

Environment

Xcelsius 2008 Service Pack 3 Fix Pack 3.2.

Reproducing the Issue

  1. Open Xcelsius 2008
  2. Insert a column chart component.
  3. Right click on the chart and select Properties.
  4. On the Properties window go to Appearance and then Text tab.
  5. Select Vertical(Value) Axis Labels.
  6. Under Number format change the format from General to Numeric and set Decimal Places to 2.
  7. In the chart vertical axis labels will be displayed as 0.00, 20.00 etc.
  8. Now to go to General tab and under Data section select excel data range.
  9. Label formatting is lost.

Cause

Excel cell format is not set to Number and by default Xcelsius gives preference to excel cell format.

Resolution

  1. In embeded excel file right click on excel cell containing value and go to Format Cells.
  2. From the Category list select Number and set Decimal places to 2.

See Also

Whenever Xcelsius component data range is aligned to excel cell it gives priority to the current excel cell format. Once the data is aligned you can then make the changes in the component properties however the formatting will be lost if the data range is aligned again to excel cells and if the format is not the same.

Keywords

KBA , BI-RA-XL , Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.5