Scatter charts plot two or more data series as points. The charts are intended to show raw data distribution of the series. The data is represented as follows:
| 1. | The first data series is represented as the x values. |
| 2. | The second data series is represented as correlated y values. |
| 3. | Any additional data series are plotted as y values correlated to the x values provided by the first series. |
As a result, a scatter chart always displays one less plot than the number of data series included.
Now let's create a scatter chart that shows maximum and average freight in each city and each year.
To create the report for the chart:
| 1. | Open a new, blank report using the Sugar CRM database and the following query: |
select * from orders
Click Next.
| 2. | Move all the fields into the right-hand box. Click Next. |
| 3. | No need to group by any field. Click Finish. |
| 4. | Right-click on each band in the outline view, and choose Delete to delete all bands except for Title and Summary. |
| 5. | Enlarge the Summary band to 500 pixels by changing the Height entry in the Band Properties view. |
To create the chart:
| 1. | Give your report a title like “Maximum and Average Freight in Years for City”. |
| 2. | Drag the HTML5 Charts element into the summary band, and select Scatter. |
| 3. | In the Outline view, right click on the chart element, and choose Edit chart properties. |
| 4. | In HTML5 Chart Properties > Chart Properties > Chart Data > Configuration create a Category with the following: |
| • | Expression: $F{shipcountry} |
| • | Value Class Name: java.lang.String |
Click OK.
| 5. | Create a second Category with the following: |
| • | Expression: $F{shipcity} |
| • | Value Class Name: java.lang.String |
Click OK.
| 6. | Create a Series with the following: |
| • | Expression: YEAR($F{orderdate}) |
| • | Value Class Name: java.lang.Integer |
Click OK.
| 7. | Add a Measure for maximum freight: |
| • | Label Expression: “Max Freight” |
| • | Value Expression: ${freight} |
| • | Value Class Name: java.math.BigDecimal |
Click OK.
| 8. | Add a Measure for average freight: |
| • | Label Expression: “Average Freight” |
| • | Value Expression: ${freight} |
| • | Value Class Name: java.math.BigDecimal |
Click OK.
Your Chart Properties dialog should look like the following:
| Scatter Chart Properties |
|  |
To change the position or layout of the legend:
| Legend Properties |
| |
| 1. | Go to Chart Properties > Chart Properties. |
| 3. | Check the boxes for Show Legend and Floating Legend. |
| 4. | Using the drop-down menus, arrange the legend to appear in the top left. |
Click OK.
To add a border to the chart:
| 1. | Click the arrow next to Chart and highlight Borders and Plot Area. |
| 2. | Create a border for your chart by using the arrows next to Border Width or by typing the number of pixels. |
| 3. | Select a Border Color, Border Radius, and Border Width. |
| Border Properties |
| |
| 5. | Save and preview your report. It should look like the following: |
| Scatter Chart |
| |
Recommended Comments
There are no comments to display.