Hello,
I'm working on a chart where I view performance between 2 dates that I enter. The only thing is when I have a weekend or dates with no data, I see it anyway in my chart. I tried to use the "text" formatting for my axis, but then I need my data array to be dynamic and as I use a FILTER formula, that doesn't seem to work...
Anyone with an advice on how to do?
I'm working on a chart where I view performance between 2 dates that I enter. The only thing is when I have a weekend or dates with no data, I see it anyway in my chart. I tried to use the "text" formatting for my axis, but then I need my data array to be dynamic and as I use a FILTER formula, that doesn't seem to work...
Anyone with an advice on how to do?