1602811 - Stacked Column chart shows duplicate values in the Y axis if the values are below 5

Stacked column chart in the Xcelsius dashboard shows
Y axis labels as 1, 1.5, 2, 2.5 etc,hence if we changed the scale to Integer with 0 decimal,
the numbers are repeating.

   1) Business Object Enterprise XI 3.1 SP3
   2) Xcelsius: 2008 SP3

  1) Launch Xcesius dashboard
  2) Create stacked column chart.
  3) Bind the chart with cells having value less than 5
  4) Preview the dashboard Y Axis Values are 1, 1.5, 2, 2.5 etc
  5) If we changed the scale to Integer (numeric with 0 decimal)
  6) The numbers are repeating in Y axis

Behavior is by design.

The behavior we are getting from xcelsius is by design, if the data for Y axis is less than 5.
You will get the Y axis as 0, 0.5,1, 1.5, 2, 2.5, if number format is general.
If we change number format from general to numeric, than value will duplicates (rounding off because decimal place is zero).
Please see attachment.

For workaround we can have two charts with dynamic visibility. If data is less than 5 we can show
Manual chart else we can show auto chart.

Stack Column Chart, Duplicate Y Axis, Repeats Y axis values, Y-axis, divisions greyed out, decimal, , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To