Robandemmy
Board Regular
- Joined
- Jul 16, 2018
- Messages
- 65
Hi
I am trying to plot daily values. The table value for the x-axis consists of a if statement that returns "" if a certain condition is not met: =IF(A52<='By category'!$E$3,Sheet4!A52,"")
My problem is that for all the cells that are false (""), an empty space is plotted on the x-axis. So if 5 cells return values and 20 do not, I get 5 values plotted and 20 blank spaces on the axis. I have tried various work arounds including the use of #N/A and other values instead of "" without luck.
Am I missing something simple?
I am trying to plot daily values. The table value for the x-axis consists of a if statement that returns "" if a certain condition is not met: =IF(A52<='By category'!$E$3,Sheet4!A52,"")
My problem is that for all the cells that are false (""), an empty space is plotted on the x-axis. So if 5 cells return values and 20 do not, I get 5 values plotted and 20 blank spaces on the axis. I have tried various work arounds including the use of #N/A and other values instead of "" without luck.
Am I missing something simple?
Last edited by a moderator:
