Hello, I would like to hide those columns with no data from the plot below. Often a split chart will be on a filtered set of the same data, and the buckets will be exclusive between the split charts (as you can see in the image).
I used to make these types of plots with Excel Pivot tables all the time. The workaround in Excel is to "hide values with no data". Is there a way to make the plot something like this instead?