How to show negative value in Pie Chart from Webi?

[Former Member]

I have below example data, I want to convert this to a pie chart in Web Intelligence, my problem is after I convert it to a pie chart, the revenue '-30' is shown as '30', looks like the pie chart is not suppor the negative value to show, I want to know if there is any workaround or solution to make the pie chart to show the negative value? Is this behavior is by design? do we have any official document to explain this?

The product I used is BOE XI 3.1 SP3.

Department Revenue

A 100

B -30

C 80

Edited by: Alex Wang on Jul 13, 2010 5:51 PM

[Former Member]

How would you expect it to be represented? Can you do it in Excel?

Pie charts, as Chris noted, are simply not valid for negative data results.

[Former Member]

Why are you showing this information as a pie chart? It doesn't make sense to try and display a negative slice in a pie chart. I can't really think of a logical way to try and draw a negative slice in a pie chart. With a pie chart you will need all your information to either all be positive or all negative, otherwise it doesn't work.

What you need is to have a bar chart, with positive and negative values on the y axis.