Highlight bars in bar Chart

[Anonymous]

Hi,

Is there any way to highlight defined differences in a bar charts between to preceding months?

for example I would like to highlight the bar of oct 2015 with a red dot since the jump between sep 2015 is big -

notes-

tried before/above functions but it is not working on bar charts. only on pivot tables.

I prefer to use a UI option rather than implementing it on script.

[Anonymous]

Hi,

Have a look

Bar Chart Highest Value Coloured

Hope it helps!!

[Anonymous]

it doesn't. I need get to the previous expression and compare it to current.

Rank() function won't help here

[Anonymous]

Hi,

Use this in Expression Tab for Background Color

if(rank(fabs(above(Expression ,1)-Expression ))=1,green())

e.g.:

if(rank(fabs(above(sum(Qty),1)-Sum(Qty)))=1,green())

Hope this solve your problem!!!

[sunny_talwar]

Would you be able to share a sample you are working with to play around with it