There seems to be too much space at the top of the y axis, the highest value in the chart is 12, and the axis goes up to 20. I would like it to be a max of 15 if the highest value is < 15.
It seems to look fine for values < 10, but soon as the values go above 10, the axis goes up to 20.
I tried setting a "maximum", with if statements, which works but when you deselect the different activities- e.g. Optimised or Milki by clicking on the legend, the axis doesn't automatically resize.
Basically i just want to be able to use if statements to set a maximum on the axis, but have the ability for it to resize when I deselect certain charts e.g. Milki, B&P etc.
Any tips?
Hi