Is there any way to write text like the heading of a sheet (eg. Colours) in a KPI chart or does it have to be a number?
I would like to use the KPI chart as a button to navigate to other sheets. Best I can do is place a text box above the KPI chart with the name of the sheet written in it.
If anyone is able to help that would be great!
With the KPI object, leave the Expression field blank and place your text in the label field. To get rid of the dash '-' change the colour to white. Final step is to expand the Appearance section and set the 'Link to sheet' option.
Downside is the format of the label text cannot be changed so the other option is, as you have mentioned, to use a text box with a hyperlink to the respective sheet.
Hope this helps.