## Creating Drill-Down Charts
FusionCharts can be easily and extensively used to create drill-down charts. All the charts in FusionCharts v3 suite support drill down for data elements i.e., in each chart type, the data plot of that chart (columns in Column Charts, Pie slices in Pie Charts etc.) can act as hotspots for the chart. Using the drill down functionality provided by FusionCharts, you can easily produce charts that enact "drill down" or "zoom in (data)" capabilities. In FusionCharts v3, you can define the following types of link for the data plot: Simple links that open in the same page Simple links that open in a new page Links that open in a specified frame Links that open in a new pop-up window Existing JavaScript functions (on the same page) to be invoked as links
Defining links for a Chart
To define a simple link for any data plot, just define the link attribute for the <set> element as under: <set ... value='2235' ... link='ShowDetails.asp%3FMonth%3DJan' ...> With the above XML, the data plot (be it column, pie or line/area anchor), when clicked, will take to the page ShowDetails.asp?Month=Jan, which might contain another chart to show detailed results for the month of January. As you will note, the above link has been URL Encoded. FusionCharts expects all the links in URL Encoded format, if you have characters special characters (like ?,&, etc.) in your link. When the user clicks on the link, FusionCharts decodes it and invokes ShowDetails.asp?Month=Jan. All the server side scripting languages provide a generic function to URL Encode any string - like in ASP and ASP.NET, we've Server.URLEncode(strURL) and so on.
XML Example:
<chart caption='Monthly Sales Summary' subcaption='For the year 2006' xAxisName='Month' yAxisName='Sales' numberPrefix='$'> <set label='Jan' value='17400' link='DemoLinkPages/DemoLink1.html'/> <set label='Feb' value='19800' link='DemoLinkPages/DemoLink2.html'/> <set label='Mar' value='21800' link='DemoLinkPages/DemoLink3.html'/> <set label='Apr' value='23800' link='DemoLinkPages/DemoLink4.html'/> <set label='May' value='29600' link='DemoLinkPages/DemoLink5.html'/> <set label='Jun' value='27600' link='DemoLinkPages/DemoLink6.html'/> </chart>
Opening links in new window
Quite often, you might want to open the drill-down link in a new window instead of the same window. To have a link open in a new window, all you need to do is, add n- before any link. E.g., <set ... value='2235' ... link='n-ShowDetails.asp%3FMonth%3DJan' ...> The above link, when clicked, would open in a new window. Example XML:
<chart caption='Monthly Sales Summary' subcaption='For the year 2006' xAxisName='Month' yAxisName='Sales' numberPrefix='$'> <set label='Jan' value='17400' link='n-DemoLinkPages/DemoLink1.html'/> <set label='Feb' value='19800' link='n-DemoLinkPages/DemoLink2.html'/> <set label='Mar' value='21800' link='n-DemoLinkPages/DemoLink3.html'/> <set label='Apr' value='23800' link='n-DemoLinkPages/DemoLink4.html'/> <set label='May' value='29600' link='n-DemoLinkPages/DemoLink5.html'/> <set label='Jun' value='27600' link='n-DemoLinkPages/DemoLink6.html'/> </chart>