Ad Hoc View – Chart Format – Advanced

  1. Home
  2. Ad Hoc Views - Charts
  3. Ad Hoc View – Chart Format – Advanced

Charts are useful tools for graphically displaying information.

Sometimes, you may wish to change the format of your charts, beyond the basic options.

There are many options available within the Chart Format tool.

Instructions

Step 1.  Open or create a new ad hoc view (refer to the Creating Ad Hoc Views article for further information)

Step 2. Select Chart from the drop-down at the top of the screen.

Select Chart

By default, a column chart is selected.

 

Step 3. To change the chart type, click the options drop down in the top left corner of the chart area.

Select Chart Options

 

Step 4. Select Chart Types… and select the required chart

Chart Types Option

 

Step 5. Add the required fields and measures to your chart.

Default Chart

 

Step 6. To change the chart format, click the options dropdown again.

Select Chart Options

 

Step 7. Select Chart Format

Chart Format

The Axis tab is displayed

Chart Format Axis tab

 

For information on formatting using the Axis tab, refer to the Ad Hoc View – Chart Format – Axis article.

 

Step 8. Click on the Advanced tab

Chart Format Advanced tab

The Advanced tab allows you to add various properties to your charts which will provide much more flexibility in your display.

Step 9. To add an advanced property, Click Add New Property

Add new property button

The property fields are displayed

Add new property fields

 

Step 10. Enter the property name in the Property field e.g. chart.margin

Property name

 

Step 11. Enter the property value in the Value field e.g. [100,200,100,200]

property value

 

Step 12. Click the green tick to save the property

Property saved

 

Step 13. Click apply to see the settings on your chart

Step 14. Click OK to exit the editor.

 

Some useful examples are below:

  • Chart background Colour
    • Set the colour of the background behind your chart
    • Property = chart.backgroundColor
    • values = supported colour name or hex code
Tip: for a list of supported colors and hex codes, 
refer to this link

Chart Background colour grey

 

 

  • Chart border Colour
    • Set the colour of the border around your chart
    • Property = chart.borderColor
    • values = supported colour name or hex code

 

  • Chart border Width
    • Set the width of the border around your chart
    • Property = chart.borderWidth
    • value = numeric

Chart Border color and width

 

 

  • Chart height
    • Set the total height of your chart
    • Property = chart.height
    • value = numeric

chart height

 

 

  • Chart width
    • Set the total width of your chart
    • Property = chart.width
    • value = numeric

Chart width

 

 

  • Data Labels
    • Display data values on your chart
    • Property = plotOptions.series.dataLabels.enabled
    • values = true or false

 

Data Labels

 

 

  • Data Labels (Pie Chart Percentage)
    • Display segment percentages on your pie chart
    • Property = series.dataLabels.enabled
    • value = true
    • Property = series.dataLabels.format
    • value = {point.name}: {point.percentage:.1f}%

Pie Chart Labels

 

 

 

 

Step 15.  To edit an advanced property, open the Chart Format window (see steps 6-8).

Step 16. Click the edit (pencil) icon next to the property.

Edit Property

Step 17. Make any required changes, then click the green tick to stop editing.

Updated property value

 

Step 18. Click Apply for the changes to appear on your chart.

 

Step 19. Click OK to close the Chart Format window.

 

Step 20. To delete an advanced property, open the Chart Format window (see steps 6-8)

 

Step 21. Click the delete (bin) icon next to the property.

Delete property

 

Step 22. Click Yes to confirm the deletion

Confirm deletion

 

The property is removed from the Advanced tab.

Chart Format Advanced tab

 

Step 23. Click Apply to remove the formatting from your chart.

Step 24. Click OK to exit the Chart Format window.

 

For more information on advanced tab formatting, refer to the Jaspersoft wiki, or click the More Information link on the Advanced tab of the Chart Format window.

 

Further information

For more information on working with chart formats, refer to the following articles:

 

Related Articles