I have a Column Series with a label overlay that can be hard to read if the graph range is too large and the amount of a particular column too small. As you can see in the attached image, if the value is $0 then I am not displaying the label at all, otherwise it will show. The problem is this graph range can be very large and some of the column can be very short, leaving the label hanging out above the column.
What I'd like to do is have the text invert colors based on what color it overlays or (probably a much simpler solution) just determine the the height of the column and change the text color manually if it's below a certain height or height percentage.
I understand this is a longshot and the solution is probably far too complicated to even put the effort into implementing so a third option would be adding a background color to just the label.
Any help is appreciated.
What I'd like to do is have the text invert colors based on what color it overlays or (probably a much simpler solution) just determine the the height of the column and change the text color manually if it's below a certain height or height percentage.
I understand this is a longshot and the solution is probably far too complicated to even put the effort into implementing so a third option would be adding a background color to just the label.
Any help is appreciated.