Crash on opening file with empty multilevel category chart

Visitor

Hi everyone - 

 

I have a file with a chart that has a multilevel x axis (e.g. year and month) and a couple of series in it. I have written some code that filters all series and categories out of the chart when nothing is selected, and the workbook starts in this state. However, once I add a multilevel axis to this chart, filter out (turn off) all series and categories, it causes excel to crash when it is opened. I figured it was something to do with my code, but I tested it on a blank excel file with the same result.

 

I'm sure everyone will say, you don't need to do that, etc., however, I would *like* to do this, and I don't see why it should be possible with single level categories, but not multi level categories.

 

Thanks!

0 Replies