How to display selected value in a chart

[#1]

For example you plot a forecast by Quarter, you can select 2  type of business : New or Retention...... What I'm trying to do is to show the 'type of business' value inside the chart

[martin59]

Hi,

You have to use the function GetFieldSelections() like this :

=GetfieldSelections([Type of business])

If you want to show the result in your chart, you can use it in the chart title or with the option "text in chart".

With this option, pay attention to the text position (top left by default), change and resize it with the shortcut  alt+shift.

He that helps you

Martin Favier

[#3]

Hi,

You can try adding this in the chart title:

=if(GetFieldSelections(Type)>0,GetFieldSelections(Type),'All')

Please check the attachment for a sample.

Is that what you are looking for?

Regards,

-Khaled.

[#4]

Many thanks to both for your prompt answer - it is working fine (now need to find a way to expand the size of the text box, but that is another story)