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 Viewsheet based on the 'Sales' > 'Sales Explore' Worksheet.
2. Drag a Chart from the Component panel into the Viewsheet grid, and resize the Chart to be wider and taller.
3. Click the 'Edit' button on the Chart to open the Chart Editor.
4. In the Chart Editor, drag the 'Total' field from the 'Measures' folder in the Data Source panel to the 'X' region of the Data panel.
5. Drag the 'Category' field from the 'Dimensions' folder of the Data Source panel to the 'Y' region of the Data panel.

6. Drag the 'Quantity Purchase' field from the 'Measurers' folder in the Data Source panel 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.
Observe that the chart now displays a column of values giving the aggregated 'Quantity Purchased' value for each 'Category' group.

9. Drag the 'Discount' field from the 'Measures' folder in the Data Source panel 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.
Observe that the chart now displays a column of values giving the aggregated 'Discount' value for each 'Category' group.
12. Right-click in the plot area and select 'Plot Properties' from the context menu. This opens the 'Plot Properties' dialog box.
13. Enable the 'Show Table Grid' option, and press 'OK'. This displays grid lines around the plot area, and around each text column.

14. Adjust the spacing between the columns by dragging on the boundaries between columns.

15. Click on each column of text in turn and set the desired formatting. (You can do this by using the toolbar buttons or by using the 'Format' dialog box. See Format Dialog Box for more information.)
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.
16. Right-click the X-axis title, and select 'Hide Title' from the context menu. Do the same for the Y-axis title.

17. Resize the chart as desired. Add text elements above the chart to provide any desired column headers.

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