Inserting labels on the sheet with fields and averages

[#1]

Good day,

Would you please assist.

I want to add a heading on the document , the heading should consist of the label ,date and average .

Example:

1 - Customer satisfaction survey overall rating of [DATE] is [AVG RATING]

2 - Data used is of from [DATE] to [TODATE]

[tresesco · Accepted solution]

Hi, You can use a TEXTBOX to get your dedired result.

use the formula as- 'Customer satisfaction.....' & [DATE]& 'is' & [Avg(RATING)]

or so depending on your field names.

Hope this would help.

[#3]

Hi,

You can also show the labels in a chart's caption by using the same expression in the 'title text' under caption tab in the object properties.

Regards,

Haneesh

[#4]

Hi i dont want to show the title on the chart.

I want to put a heading which is not linked to anything on the sheet which will be the heading for everything not for a particular object.