I am having a problem regarding the minimum value of y-axis on a combination chart. I already set the minimum value to - 20 but at some point the chart still shows values lower than -20. And, sometimes it follows the rule that -20 is the minimum value. I still don't know why it happens. :o Does anyone know what I did wrong that causes this behavior? Thanks in advance. ;D
Could you try to find some sort of constancy? Isolate several scenarios where the axis goes below twenty, and several scenarios where the rule is enforced, and see what is common between them. Because as it is, it's difficult to offer any help.
Hi Nimrod,
Thanks for the reply. I tried to trace what causes that behavior and I noticed that the chart assumes that there is a negative value based on the value that is passed to it and not with the calculated value or the percentage. My y-axis is the percentage of each series. Do you know how to make it check if there is a negative value on percentage and not with the value supplied to it?Thanks in advance.