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!
Nothing attached, make sure you press the Start Upload button after you select files.
Re-attaching. Thanks.
Hi Shawn,
Hard to debug based on images, if you can attach a sample workbook that can reproduce the problem will be easier to check.
I would check the named ranges if they return the correct range in both cases.
Velouria provided the answer:
Amend the formula to:
=IF(COUNTA(ReportBurndown!$X$2:$X$2)>0, OFFSET(ReportBurndown!$W$2,,,MAX(2,COUNTA(ReportBurndown!$Y$2:$Y$9999)),2),0)
