How to Utilize plotBands Feature in Ad Hoc Chart

Use case

Customer created an Ad Hoc Chart and wants to utilize plotBands feature available in Highcharts library.

Resolution

Highcharts' plotBands is an array of objects defining plot bands on a axis:

https://api.highcharts.com/highcharts/yAxis.plotBands

In order to utilize plotBands in Ad Hoc Chart designer, you need to go to 'Chart Format' menu, 'Advanced' tab and manually type yAxis.plotBands property name and array of objects escaped in double-quotes as a value, e.g.:

[{"color":"red","from":"0","to":"1000"},{"color":"yellow","from":"2000","to":"4000"},{"color":"green","from":"6000","to":"8000"}]

Please refer to printscreen

Solution tested with TIBCO JasperReports^® Server v.7.1.0

Ref. Case 01637993