I'm trying to hide some bars and the line on my combo chart but without affecting the calculation.
My bar chart is like the following:
I'm trying to hide the bars and the line from W14 to W17, since I'm using the rangesum function and the sum is five-week based so the data before W18 is not accurate.