Tutorial: Creating Drilldown Charts with FusionCharts for Dreamweaver

FusionCharts for Dreamweaver helps Web programmers to create animated Flash charts from an easy to use Dreamweaver interface. FusionCharts for Dreamweaver comes with 36 Web ready chart types including line, area, bar, column, doughnut, combination, scroll charts and more.
All the charts are animated & interactive, which makes it a delightful experience for the end user. The interactivity options include tooltips, rotation, switching from 3D to 2D and then back again, and even slicing the wedges in a pie chart.
With the Drill Down Chart Links feature you can place links behind the plotted areas of a chart. Typical usage is to give the users the possibility to click on a chart element and get to a new page that can include a drill down chart or detailed explanations. For example, in the chart below, the user can click on the February column and get to a new page that includes a detailed chart with the February sales.

Regular chart

Drill Down chart
Setting up drill down links in Static Charts
Creating Drill Down charts for an existing chart consists in 2 steps:
- Generate the secondary chart (static or dynamic). The secondary chart is a regular chart created on a data subset of the main chart. In the example above, you should create a secondary chart to show the sales of John, Mary and Tom in February.
- Link the plotted area to the secondary chart. Attaching drill down links to the plotted area in the static charts is very easy. From the "Data Grid" tab, click on each value in the grid and set the link to the secondary chart and target.

Set the Drill Down link
Setting up drill down links in Dynamic Charts
As for the Drill Down links in Static charts (see above) you should first create the secondary chart (the chart where that the user can see after clicking on a plotted area in the main chart. To create the Drill Down link dynamically you need to add 2 fields in the database table: one to contain the drill Down link and one to indicate the link target.
To link the plotted areas accordingly to the database values go to the "Data" tab (Use data from already defined recordset screen) and click on "Add as series" button. In the pop-up you should fill in the Link field and select the column used to set the target. The link field should be composed from the URL of the secondary chart and the database column that contains the parameter that identifies the secondary chart.

Set the Drill Down link dynamic



