Bar chart above and below zero values

[#1]

Can anyone help me to create a bar chart that would show positive and negative values for a category in one bar (or at least make it appear like one bar) above and below the 0 axis?  I'm trying to show gains and losses by category.

Above is a screen shot of what i want it to look like and I've attached a sample doc with data and the chart as close as i can get it.

[jagan · Accepted solution]

Hi,

Try like this

Dimension : ProductID

Expressions:

Enrolled : =Sum(Enrolled)

Cancelled: =Sum(Cancelled)*-1

Now Chart Properties-> Style-> Select subtype as Stacked

Hope this helps you.

Regards,

Jagan.

[#3]

See attached,

is this what you are trying, your requirement wasn't much clear.

Cheers

[#4]

Perfect!  The 'stacked' property is what i was overlooking.  Thanks!