I have seen some of the Margin workarounds and they do not seem to work well.
If I can't do this then is it possible to just set the color of the bars by a field in my data table?
I will do absolute values and have a third field in my datatable (1 or 0).
if 1 then Red bar(negative) if 0 Green bar (positive)
So the table being set to the data source would be like
Western Oil / 2 /1 (so 2 is negative thus red)
Sanders Oil / 3 /0 (so 3 is positive thus green)
I would prefer to do this programically is possible...
Set the datasource then change the colors... but perhaps it can not be done programmically..
Any help would be great.