Bar Chart Dynamic Label

[GrantBooth]

I'm trying to set the label to the Y access on a bar chart to return a customised label, and I'm having limited success.

My chart has the following variables

A drilldown menu with hierarchy 

Channel_1 -> Channel_2 -> Channel_3-> Channel_Name

My sheet also has a financial year selection, and users can also select the State on a map.

Perfect world, I would like the label on the chart to do the following

Omit name of Channel_1

and show [name of Channel 2, name of Channel 3, name of Channel_Name and Financial Year]

So it might look like  Vic State, Comics Region, DC Comics, Batman 2021

I've tried using GetCurrentSelections but it is returning all values, what am I missing?

[anthonyj]

Hi Grant, 

You could try using the GetFieldSelections to target the field values more specifically. Something like this should create a list of values selected from these fields.

=GetFieldSelections([Channel_1]) & ' ' & GetFieldSelections([Channel_2]) & ' ' & GetFieldSelections([Channel_3])& ' ' & GetFieldSelections([Channel_Name])& ' ' & GetFieldSelections([Financial Year])

I hope this helps.

Anthony

[GrantBooth]

Thank you, I managed to get that to work