Vertical Chart Axis Shows One Level when Expecting Two|Power Query|Excel Forum|My Online Training Hub

Hello -

I have a standard (non-pivot) chart based on named ranges which in turn are based on a pivot table. Note that the table begins in Column B Row 41, as follows:

[ART]; [Team]; [Low]; [High]
[Sample ART]; [Yankees]; [20]; [24]
[Sample ART]; [Mets]; [22]; [26]
[Sample ART]; [Giants]; [23]; [25]

Named Range: MyChartAxis=OFFSET(rptRange!$B$41,,,COUNTA(rptRange!$F$41:$F$1000),2)

The chart (see attached) visualizes a range of performance values for my teams, each of which belongs to an ART (Agile Train). For example, within "Sample ART" I have the Yankees with values 20-24, the Mets with 22-26, and the Giants with 23-25. The chart renders as expected -- except for the vertical axis.

As you can, when more than one team is selected in the slicer, the vertical axis shows the ART name and the selected team names. However, if only one team is selected, then the axis does not show the ART name at all. Since team names are not unique across ARTs, this can cause confusion as to which team we're actually looking at.

How do I get the vertical axis to always show the ART name?

Thanks!