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

SAP Knowledge Base Article - Public

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

Symptom

  • 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

Cause

By design

Resolution

See attachment for a workaround 

Keywords

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

Product

SAP BusinessObjects Xcelsius Enterprise 2008

Attachments

KB Xcelsius - Remove null values.doc