If you instead make a chart from multiple rows and multiple columns, Excel will make one dimension the x-axis and make the other into different series.

This is a confirmed bug: when the axis column in an Echarts chart has a label (verbose name) defined at the dataset level, Drill to Detail (D2D) by axis value does not filter correctly and shows all ...