Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to change the title of the chart based on selection done at the multibox. Please suggest is it feasible without macros??
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.
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.