Xen
Member
Hello, I have a problem where my formula-generated data can't create gaps in chart.
Zeros, well, they makes your chart look like disaster
na() is a huge help in the begging and the end of chart, works as intended, however, na()'s in the middle of the chart does not create gaps, values before errors get connected instead, which is totally not the way I want it.
I want to put something in formula or turn on some option (haven't found anything helpful myself) that will make gaps in chart for me, like if cell was truly blank (I can't make blanks manually, data gets pulled from other sheets, users choice)
Is there a workaround for this?
Zeros, well, they makes your chart look like disaster
na() is a huge help in the begging and the end of chart, works as intended, however, na()'s in the middle of the chart does not create gaps, values before errors get connected instead, which is totally not the way I want it.
I want to put something in formula or turn on some option (haven't found anything helpful myself) that will make gaps in chart for me, like if cell was truly blank (I can't make blanks manually, data gets pulled from other sheets, users choice)
Is there a workaround for this?