Recordset method

The recordset-method assumes that you have already retrieved the desired data from the database through some queries and stored it in one or more recordsets.

Following, the FusionCharts data configuration is pretty straightforward.

1. In order to define the chart’s category, select a recordset from the list and then select one of its columns from the drop-down list below. If you want to read more about recordsets, read the How to create a recordset in Dreamweaver tutorial.
2. In order to add a series to the data to be plotted, select a recordset from the list and then select one of its columns from the drop-down list below. Finally, click Add As Series to add the column values as a data series to be plotted. Repeat step 2 until you have all the data series you need for plotting the chart.

In order to remove a data series from the chart, select it in the series list and click the Remove Series button.

Sort the chart data

The data based on which the chart will be plotted can be sorted in asceding order or in descending order based either on the chart data series or on the chart category. The sorting options can be found in the Series Data step of the data configuration wizard, and they are:

None Applies no sorting on the chart data.
Sort By Category The data will be sorted with respect to the chart's category.
Sort By Series The data will be sorted with respect to one of the chart's series, which can be selected in the series list.
Ascending Sorts the data starting with the lowest values.
Descending Sorts the data starting with the highest values.

You can preview the data which will be used to plot the chart by pressing the Preview Data button.