Creating a Table-Chart Hybrid

This example illustrates how to create a chart that has features of a table, in particular, a columnar display of data. Follow the steps below:

1. Create a new report. Drag a Chart element from the Toolbox panel into the report.

2. Click on the Chart to open the Chart Editor.

3. In the Data Source panel, expand the 'Data Source' node, then expand the 'Orders' data source, and then expand the 'Order Model'.

4. From the Data Source panel, drag the 'Total' field of the 'Product' entity to the 'X' region of the Data panel.

5. From the Data Source panel, drag the 'Category' field of the 'Product' entity to the 'Y' region of the Data panel.

 

6. From the Data Source panel, drag the 'Quantity Purchased' field of the 'Product' entity to the 'Y' region of the Data panel (under 'Category').

7. Press the 'Edit Measure' button next to 'Quantity Purchased'. Set the 'Aggregate' property to 'Sum' and enable the 'Discrete' option. This allows the measure to behave as a dimension.

 

8. Press the green 'Apply' button.

Preview the report and observe that the chart now displays a column of values giving the aggregated 'Quantity Purchased' value for each 'Category' group.

 

9. From the Data Source panel, drag the 'Discount' field of the 'Order' folder to the 'Y' region of the Data panel (under 'Quantity Purchased').

10. Press the 'Edit Measure' button next to 'Discount'. Set the 'Aggregate' property to 'Average' and enable the 'Discrete' option. This again allows the measure to behave as a dimension

 

11. Press the green 'Apply' button.

Preview the report and observe that the chart now displays a column of values giving the aggregated 'Discount' value for each 'Category' group.

12. Right-click on the chart, and select 'Properties' to open the 'Chart Properties' dialog box.

13. Click in the plot area to open the 'Plot Property' panel below.

14. Enable the 'Show Table Grid' option, and press 'Apply'. This displays grid lines around the plot area, and around each text column.

 

15. Drag on the boundaries between columns to adjust the spacing between the columns as desired.

 

16. Click on each column of text in turn and set the desired formatting in the 'Axis Label Property' panel below. (See Formatting for more information about formats.)

For example, set a number format for the 'Quantity Purchased' column and set a percent format for the 'Discount' column. Center-align both of these columns, and left-align the 'Category' column.

17. Right-click the X-axis title, and select 'Hide Title' from the context menu. Do the same for the Y-axis title.

18. Press 'OK' to close the 'Chart Properties' dialog box, and preview the report.

 

19. Resize the chart as desired. Add text elements above the chart to provide any desired column headers. (For precise positioning, place the text elements within a Section Element.)

 

<< Creating a Candle Chart © 1996-2013 InetSoft Technology Corporation (v11.5) Creating a Dot Plot >>