Conditional Format Bar Chart

[Will85]

My data is very simple. I have Fav(Unfav) variances by department.

I want to use a bar chart, however I want to display the absolute value of the data, but format the departments that were unfavorable a different color.

I don't like (I don't have enough space) how the negative departments go one way, and the positive another. I want them all to go the same direction, however differentiate the fav(unfav) by color.

I thought about maybe adding a 1 or zero as another data set for each department that would conditionally change if the variance changes, but not sure how I could incorporate that into the chart to drive the formatting.

 

[Sergius]

Let's say you have a table like this

Original table
Name Dep	value
Dep_1	515,60
Dep_2	-311,59
Dep_3	389,23
Dep_4	-321,38
Dep_5	374,94
Dep_6	444,51

In order to display positive and negative departments in different colors on one axis, you need to create a separate table like this

Data for plotting the chart
positive	negative
515,60	0,00
0,00	311,59
389,23	0,00
0,00	-321,38
374,94	0,00
444,51	0,00

The point of this table is that in the first column we display data for positive departments, and for negative ones we put "0", in the second column we do the opposite, we write data for negative departments, and for positive ones we put "0". After that we build a diagram based on this table, only we take the names of the departments from the first one.
As a result, you will get a histogram like this with different colors for positive and negative departments.