Varying bar graph color for values above and below zero

[excel_stuff]

Hi,

I have a bar graph which takes values from a slider. What I need is to show is that values below zero in the bar graph should be in red and above should be in green. The challenge is that as the slider moves, the values change (as above or below zero) and I want them displayed in different colors depending on whether they are above or below zero.

Can anyone help please? I don't know if I have explained myself well but I can clarify.

Thanks
S

 

[Somendra Misra]

@excel_stuff

If you are using Excel 2010, this can be done through formatting fill property of chart.

Regards,

 

[excel_stuff]

Excellent! Great advice. Worked like a joy!

 

[Xiq]

Hi there,

You can try doing the following:

• Create a new sheet for your dashboard calculations
• make a little table where you have 2 rows, populated with formula's to split the positive from the negative numbers (*)
• select this table and create a stacked bar-chart
• Format the chart as you see fit

The formula's can look like this:

=IF(A1>=0,A1,NA())

for the positive row

=IF(A1<0,A1,NA())

for the negative row

 

[excel_stuff]

Thanks, Xiq, that's also a clever way to address this if one didn't have Excel 2010. Cheers.