Adding dynamic text to chart titles

[Anonymous]

Is there a way to add dynamic text to a chart title when a user selects more than one value in a list box i.e. if a user selects three regions in a list box how do I display all three regions in the chart title?

Thanks

[v_petrenko · Accepted solution]

Hi Greg, put this expression into Title property of the chart (open chart properties with it's context menu):

='Regions: ' & Concat( DISTINCT [Region], ', ' )

Please mark the answer as correct and your question as answered if it helped.

[Anonymous]

Try adding this to the chart title:

=concat(Distinct YourDimension,', ')

Regards,

Gabriel

[Anonymous]

Thanks Vasily.  That worked.  But is there a way to get the list of regions to span more than one line in the chart.  It is trying to list them all on one line and there isn't enough room.

Greg

[deepak_km9886]

Go to your sheet appearance and title section then add this expression manually

='Selected Region: ' & Concat(Distinct [Region Dimension],',')

[sunny_talwar]

You can try this:

='Regions: ' & Concat( DISTINCT [Region], Chr(10))

[Anonymous]

I just added a return as follows and it put each region on a separate line -

='Regions: ' & Concat( DISTINCT [Region], ',

' )

[sunny_talwar]

Sure that is an option as well