SAP Knowledge Base Article - Public

1232690 - Xcelsius 2008 - How to remove a null values (zero) in the legend of pie charts.


  • Want to take off/suppress the empty values (0) displayed in Pie chart legend

Reproducing the Issue


  1. Open Xcelsius2008
  2. Create a table with a serie of values like:
Product A= 100
Product B= null
Product C= 50
Product D= 40
Product E=null
  1. display this table in a pie chart
  2. Product A, C and D displayed only on the graph
  3. Product A, Product B, Product C, Product D, Product E displayed on the legend
  4. Apply the option "ignore blank cells at End-of-Range"
  5. Issue resolved for product E
  6. Issue remained for product B
  •  Xcelsius 2008


By design


See attachment for a workaround 


0, remove, suppress, chart, , KBA , BI-RA-XL , Obsolete: BusinessObjects Dashboards and Presentation Design , How To


SAP BusinessObjects Xcelsius Enterprise 2008


KB Xcelsius - Remove null values.doc