Change the Title of chart at Runtime

[#1]

Hi,

I want to change the title of the chart based on selection done at the multibox. Please suggest is it feasible without macros??

[Miguel_Angel_Baeyens · Accepted solution]

Hello,

You can use the following:

='Fixed text ' & Concat(DISTINCT Field, ',')

If you select values "A" and "B" in Field, then it should look like

Fixed text A, B

Hope this helps.