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. Click on the Select Visualisation Type icon in the top menu
Visualisation Type Icon
The Select Visualisation Type window is displayed
Step 3. Select the required chart type from the list. You can select a category on the left to narrow down the list.
Step 4. Select the required chart Step 5. Add the required fields and measures to your chart. Default Chart Step 6. To change the chart format, click the options dropdown. 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