How to put both -ve and +ve value in same bar chart

[#1]

In a column of a table if contains both -ve and +ve value how we can put both -ve and +ve value in bar chart.

[prieper]

A bar-chart should have no problem to display -ve and +ve values, in a pie-chart you may have a problem.

Peter

[#3]

I am displaying Yearly SalesValue in one bar and wants to display the variance of sales(difference in salesvalue when compared to last year) in another bar. But i am unable to display the bar (variance of sales ) which contains both +ve and -ve values. Please help me out.

[shumailh]

I think the variance you have in your data is very minor that's why you can't be able to see it in a graph, I have designed the same senario in the attachement,

Regards,
Shumail Hussain

[shumailh]

graph will be showing like this, if the values are smaller in variance field then you require to work on the design of the graph.

Regards,
Shumail Hussain

[#6]

Variance value are larger enough to be displayed as bar and infact it is larger than the sales value which are displayed as a bar.

[shumailh]

Have you tried the attachement which i shared earlier? are you still facing problem with the garph if then can you share your graph?

Regards,
Shumail Hussain

[#8]

I am using personal edition so will not be able to open your application. One more thing is that when i don't add the variance field in the expression then sales label is getting displayed in the chart or else it is not getting displayed.

[shumailh]

To hide/unhide label use the below property.

[#10]

I knew that i was just sharing you my personal scenario here. By the way in expression SalesValue: Sum (SalValue) and the Variance: (Sum(SalValue) - before(Sum(SalValue))) Hope you can get some idea where i am going wrong.