Using FusionCharts XT with ASP - Basic Examples | ||||||||||||||||||||||||
FusionCharts XT can effectively be used with ASP to plot dynamic data-driven charts. Even when used with ASP, FusionCharts XT internally uses JavaScript and XML/JSON to render the charts. The ASP code actually helps you output this JavaScript and XML/JSON. To aid your understanding of this section, we will recommend you to go through the following sections of documentation (if you have not already read them):
In this section, we will show a few basic examples to help you get started. We will cover the following examples here:
Let's quickly see each of them. Before you proceed with the contents in this page, we strictly recommend you to please go through the How FusionCharts XT works? section All code discussed here is present in Download Package > Code > ASP > BasicExample folder. |
||||||||||||||||||||||||
Setting up the charts for use | ||||||||||||||||||||||||
In our code, we have used the charts and JavaScript class files contained in Download Package > Code > FusionCharts folder. When you run your samples, you need to make sure that the SWF files are in proper location. |
||||||||||||||||||||||||
Plotting a chart from data contained in Data.xml | ||||||||||||||||||||||||
Let's now build our first example. In this example, we will create a "Monthly Unit Sales" chart using Data URL method. For a start, we will manually code our XML data in a physical XML document Data.xml and then utilize it in our chart contained in an ASP Page (SimpleChart.asp). The chart will look like the image shown below: Let's first have a look at the XML Data document: |
||||||||||||||||||||||||
<chart caption='Monthly Unit Sales' xAxisName='Month' yAxisName='Units' showValues='0' formatNumberScale='0' showBorder='1'> <set label='Jan' value='462' /> <set label='Feb' value='857' /> <set label='Mar' value='671' /> <set label='Apr' value='494' /> <set label='May' value='761' /> <set label='Jun' value='960' /> <set label='Jul' value='629' /> <set label='Aug' value='622' /> <set label='Sep' value='376' /> <set label='Oct' value='494' /> <set label='Nov' value='761' /> <set label='Dec' value='960' /> </chart> |
||||||||||||||||||||||||
This XML is stored as Data.xml in the Data Folder in the BasicExample folder. It basically contains the data to create a single series chart to show "Monthly Unit Sales". We will plot this on a Column 3D Chart. Let's see how to do that. To plot a Chart that consumes this data, you need to include the HTML + JavaScript code to embed a chart object and then provide the requisite parameters. To make things simpler for you, we have put all this functionality in an ASP function named as renderChart(). This function is contained in Download Package > Code > ASP > Includes > FusionCharts.asp file. So, whenever you need to work with FusionCharts XT in ASP, just include this file in your page and then you can work with FusionCharts XT very easily. Let's see it in example. SimpleChart.asp contains the following code to render the chart: |
||||||||||||||||||||||||
<% 'We've included ../Includes/FusionCharts.asp, which contains functions 'to help us easily embed the charts. %> <!-- #INCLUDE FILE="../Includes/FusionCharts.asp" --> <HTML> <HEAD> <% 'You need to include the following JS file, if you intend to embed the chart using JavaScript. 'When you make your own charts, make sure that the path to this JS file is correct. Else, you 'will get JavaScript errors. %> <SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT> <TITLE>FusionCharts XT - Simple Column 3D Chart</TITLE> </HEAD> <BODY> <% 'Create the chart - Column 3D Chart with data from Data/Data.xml Call renderChart("../../FusionCharts/Column3D.swf", "Data/Data.xml", "", "myFirst", 600, 300, False, True) %> </BODY> </HTML> |
||||||||||||||||||||||||
As you can see above, we have :
|
||||||||||||||||||||||||
|
||||||||||||||||||||||||
When you now run this page, you'll see a chart like the one below. If you do not see a chart like the one below, please follow the steps listed in Debugging your Charts > Basic Troubleshooting section of this documentation. |
||||||||||||||||||||||||
Advanced note : Apart from renderChart()function, FusionCharts.asp provides a number of functions (listed below) to ease your implementation.
So, you just saw how simple it is to create a chart using ASP and FusionCharts XT. Let's now convert the above chart to use the Data String method. |
||||||||||||||||||||||||
Changing the above chart into a single page chart using the Data String method | ||||||||||||||||||||||||
To convert this chart to use the Data String method, we create another page dataXML.asp in the same folder with following code: |
||||||||||||||||||||||||
<% 'We've included ../Includes/FusionCharts.asp, which contains functions 'to help us easily embed the charts. %> <!-- #INCLUDE FILE="../Includes/FusionCharts.asp" --> <HTML> <HEAD> <% 'You need to include the following JS file, if you intend to embed the chart using JavaScript. 'When you make your own charts, make sure that the path to this JS file is correct. Else, you 'will get JavaScript errors. %> <SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT> <TITLE>FusionCharts XT - Simple Column 3D Chart using dataStr method</TITLE> </HEAD> <BODY> <% 'Create an XML data document in a string variable strXML = "<chart caption='Monthly Unit Sales' xAxisName='Month' yAxisName='Units' showValues='0' formatNumberScale='0' showBorder='1'>" strXML = strXML & "<set label='Jan' value='462' />" strXML = strXML & "<set label='Feb' value='857' />" strXML = strXML & "<set label='Mar' value='671' />" strXML = strXML & "<set label='Apr' value='494' />" strXML = strXML & "<set label='May' value='761' />" strXML = strXML & "<set label='Jun' value='960' />" strXML = strXML & "<set label='Jul' value='629' />" strXML = strXML & "<set label='Aug' value='622' />" strXML = strXML & "<set label='Sep' value='376' />" strXML = strXML & "<set label='Oct' value='494' />" strXML = strXML & "<set label='Nov' value='761' />" strXML = strXML & "<set label='Dec' value='960' />" strXML = strXML & "</chart>" 'Create the chart - Column 3D Chart with data from strXML variable using Data String method Call renderChart("../../FusionCharts/Column3D.swf", "", strXML, "myNext", 600, 300, False, True) %> </BODY> </HTML> |
||||||||||||||||||||||||
As you can see above, we:
When you see this chart, you will get the same results as before. |
||||||||||||||||||||||||
Using the FusionCharts HTML embedding method to render chart | ||||||||||||||||||||||||
You can also create charts using the HTML embedding method. It creates HTML <object>/<embed> tags to render chart. It does not require FusionCharts.js to be included in the page. HTML embedding method is deprecated. Many of the features of FusionCharts XT that works in collaboration with JavaScript, like providing JSON data, advanced event-handing, setting chart attribute etc., will wont work using this method. Again, to make things simpler for you, we have provided an ASP function called renderChartHTML() which helps you render chart using <object>/<embed> tag and you do not have to get your hands dirty with HTML tags. This function is also contained in the previously used FusionCharts.asp file. Let's now quickly put up a sample to show the use of this function. We make a copy of our SimpleChart.asp (which rendered chart using the Data URL method from Data.xml file ) file and rename it to BasicChart.asp. We load the data from our previously created Data.xml file. The modification involves a single line change from the previous file and the modified code (modification in bold) will look like the following : |
||||||||||||||||||||||||
<% 'We've included ../Includes/FusionCharts.asp, which contains functions 'to help us easily embed the charts. %> <!-- #INCLUDE FILE="../Includes/FusionCharts.asp" --> <HTML> ... <% 'Create the chart - Column 3D Chart with data from Data/Data.xml Call renderChartHTML("../../FusionCharts/Column3D.swf", "Data/Data.xml", "", "myFirst", 600, 300, True) %> </BODY> </HTML> |
||||||||||||||||||||||||
As you can see above, we have:
The renderChartHTML() method takes in the same parameters as the renderChart()function expect for the last registerWithJS parameter. The above example shows how you can load data using the Data URL method. You can always use the Data String method to pass XML as string using the renderChartHTML() method. |
||||||||||||||||||||||||
Create pure JavaScript charts | ||||||||||||||||||||||||
FusionCharts XT allows you to create pure JavaScript-only charts that does not require Flash, hence enabling your chart in browsers where Flash is not supported like in iPhone and iPad, etc. This is achieved by calling the FC_SetRenderer function in ASP before you render your chart. Using this function you need to set the current chart renderer to javascript. The code snippet below shows how you can achieve this: FC_SetRenderer( "javascript" ) ... Call renderChart("../../FusionCharts/Column2D.swf", "Data/Data.xml", "", "chart1", 600, 300, False, True) The above code creates pure-JavaScript chart as shown in the image below:
|
||||||||||||||||||||||||
Use JSON data to create chart | ||||||||||||||||||||||||
You can provide chart data in JSON format. You need to call the FC_SetDataFormat function and set the data format to 'json' through it. Once done, you can pass the JSON data through the renderChart() function. If you need to pass JSON data contained in a URL, use the dataUrl parameter. If you have JSON as string, use the dataStr parameter. The code snippets below illustrate how you can do these: 'Set chart data format to json FC_SetDataFormat("json") 'Create the chart - Column 3D Chart with data from Data/Data.json Call renderChart("../../FusionCharts/Column3D.swf", "Data/Data.json", "", "myFirst", 600, 300, False, True) FusionCharts XT needs JSON to be passed in a specific format. Please read FusionCharts XT Data Formats > JSON section for more on this. Please note that JSON data format is not supported in renderChartHTML function as JSON is interpreted by FusionCharts.js, which is not used in HTML embedding mode. |
||||||||||||||||||||||||
Create multiple charts in a single page | ||||||||||||||||||||||||
Creating multiple charts in a page is as easy as creating a single chart. The code below shows how you can call renderChart() function and create as many charts as you wish. All you need to take care is that you should set unique chart id to each chart as highlighted in bold below: 'Create the chart - Column 3D Chart with data from Data/Data.xml Call renderChart("../../FusionCharts/Column3D.swf", "Data/Data.xml", "", "chart1", 600, 300, False, True) 'Now, create a Column 2D Chart Call renderChart("../../FusionCharts/Column2D.swf", "Data/Data.xml", "", "chart2", 600, 300, False, True) 'Now, create a Line 2D Chart Call renderChart("../../FusionCharts/Line.swf", "Data/Data.xml", "", "chart3", 600, 300, False, True) |
||||||||||||||||||||||||
Create transparent chart | ||||||||||||||||||||||||
You can create charts with transparent backgrounds. This makes the chart show to what lies below it in HTML. To do this you need to follow these steps:
Below is a sample code with a chart having transparent background : <% 'We've included ../Includes/FusionCharts.asp, which contains functions 'to help us easily embed the charts. <!-- #INCLUDE FILE="../Includes/FusionCharts.asp" --> %> <HTML> <HEAD> <SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT> </HEAD> <BODY> <div style="padding:40px; background-color:#9d7fbd; border:1px solid #745C92; width: 600px;"> <% strXML = "<chart bgAlpha='0,0' canvasBgAlpha='0' caption='Monthly Unit Sales' xAxisName='Month' yAxisName='Units'>" strXML = strXML & "<set label='Jan' value='462' />" strXML = strXML & "<set label='Feb' value='857' />" strXML = strXML & "<set label='Mar' value='671' />" strXML = strXML & "<set label='Apr' value='494' />" strXML = strXML & "<set label='May' value='761' />" strXML = strXML & "<set label='Jun' value='960' />" strXML = strXML & "<set label='Jul' value='629' />" strXML = strXML & "<set label='Aug' value='622' />" strXML = strXML & "<set label='Sep' value='376' />" strXML = strXML & "<set label='Oct' value='494' />" strXML = strXML & "<set label='Nov' value='761' />" strXML = strXML & "<set label='Dec' value='960' />" strXML = strXML & "</chart>" Call SetTransparentChart(True) Call renderChart("../../FusionCharts/Column3D.swf", "", strXML, "myFirst", 600, 300, False, True ) %> </div> </BODY> </HTML> In the code above we have:
The chart will look as shown below. The purple color of the DIV below the chart is visible through the body of the transparent chart.
|
||||||||||||||||||||||||
Set managed printing for Mozilla browsers | ||||||||||||||||||||||||
FusionCharts XT provides better-print feature for all Mozilla, WebKit, and Gecko based browsers like Firefox, Safari, etc. To enable this feature in ASP all you need to do is call the FC_EnablePrintManager() function once in your page(preferably at the beginning or end). This enables the print manager to process print data from all the charts in a page and prepare the charts for better-quality printing. To read more on how print manager works, please go through this. Note: Print Manager works only in browsers that supports canvas object. The code below shows how you need to enable print manager through ASP: Call FC_EnablePrintManager(true)
...
'Render chart
Call renderChart("../../FusionCharts/Column3D.swf", "Data/Data.xml", "", "chart1", 600, 300, False, True)
|
||||||||||||||||||||||||
Listening to Print Manager status using JavaScript Print Manager takes a bit of time to prepare all charts present in a page for print. You can listen to Print Manager's Ready State event using FusionCharts JavaScript class. Once the charts are ready, which can be tracked by listening to an event raised by the Print Manager, you can use browser's File → Print menu, JavaScript's native window.print() function or Print Manager's advanced function - managedPrint(). The JavaScript code below shows how you can listen to the event and prepare for print: <html> ... <body> <script type="text/javascript"><!-- FusionCharts.addEventListener ( FusionChartsEvents.PrintReadyStateChange , function (identifier, parameter) { if(parameter.ready){ alert("Chart is now ready for printing."); document.getElementById('printButton').disabled = false; } }); // --></script> <input type="button" onclick="FusionCharts.printManager.managedPrint()" value="Managed Print" disabled="disabled" id="printButton" > ... </body> </html> In the above code we :
Now, if you try printing from File → Print menu or using a button or function that call the window.print() function. You can also click the "Managed Print" button to print the chart. How Print Manager Works:
|
||||||||||||||||||||||||
Creating multi-series chart | ||||||||||||||||||||||||
Unlike the single set of data which we have plotted in the above charts, you might want to compare data of multiple months. In that case, you will need to create Multi-series charts. In the sample below we will learn how to create a Multi-series chart having data for two years. The chart will look like the image shown below: To create a multi-series chart, all you need to do are:
Let's take a sample Multi-series data with monthly sales figures of two years as shown below (saved as MSData.xml): |
||||||||||||||||||||||||
<chart caption='Business Results 2005 v 2006' xAxisName='Month' yAxisName='Revenue' showValues= '0'numberPrefix='$'> { |
||||||||||||||||||||||||
Let's now render the chart with this above data. <% 'We've included ../Includes/FusionCharts.asp, which contains functions 'to help us easily embed the charts. %> <!-- #INCLUDE FILE="../Includes/FusionCharts.asp" --> <HTML> <HEAD> <% 'You need to include the following JS file, if you intend to embed the chart using JavaScript. 'When you make your own charts, make sure that the path to this JS file is correct. Else, you 'will get JavaScript errors. %> <SCRIPT LANGUAGE="Javascript" SRC="../../FusionCharts/FusionCharts.js"></SCRIPT> <TITLE>FusionCharts XT - Multi-series Column 3D Chart</TITLE> </HEAD> <BODY> <% 'Create the chart - Multi -series Column 3D Chart with data from Data/MSData.xml Call renderChart("../../FusionCharts/MSColumn3D.swf", "Data/MSData.xml", "", "myFirst", 600, 300, False, True) %> </BODY> </HTML> |
||||||||||||||||||||||||
In the above code we have done the following:
The generated chart will look like the following screen-shot: Please note that you can also use JSON data instead of XML. To achieve this, you will just need to declare FC_SetDataFormat("json") and pass your data as JSON instead of XML as shown in Use JSON data to create chart section above. |
||||||||||||||||||||||||
Creating stacked chart | ||||||||||||||||||||||||
You can also show the cumulative sales figures of each month in grouped column in stacked charts. It is very easy to create a Stacked chart once you are ready with a Multi-series data as shown in the previous example. The stacked chart will render similar to the image shown below: To render the above chart, you will only need to provide the same multi-series data as shown in the previous example and use a Stacked chart SWF file as shown in the code section below: <% 'Create chart - stacked Column 3D Chart with data from Data/MSData.xml Call renderChart("../../FusionCharts/StackedColumn3D.swf", "Data/MSData.xml", "", "myFirst", 600, 300, False, True) %> |
||||||||||||||||||||||||
Creating a combination chart | ||||||||||||||||||||||||
You can wish to combine various chart types and display in a single canvas. You can achieve this using a Combination chart. To keep it simple, let's re-use the Multi-series data we used in the previous example. We will render the data for 2006 as a Column chart and data for 2005 as Area chart. The desired chart will be similar to the image shown below: To achieve this, we have done the following modifications:
|
||||||||||||||||||||||||
Creating a combination chart showing multiple units using Dual Y Axis chart | ||||||||||||||||||||||||
So far, we have been working with data having a single unit - revenue. However, it is also possible to combine a chart of another unit like Quantity using a Dual Y Axis chart. Let's create a chart which shows total quantity sales in two years along with revenue of two years. The chart will look as follows: To achieve this, we will need to use a Dual Y Axis chart SWF file. Additionally, we will also add another set of data containing the total quantity in XML or JSON. The data with revenue and total quantity data is as follows: |
||||||||||||||||||||||||
<chart caption='Business Results 2005 v 2006' xAxisName='Month' yAxisName='Revenue' showValues= '0'numberPrefix='$'> { |
||||||||||||||||||||||||
The above data is derived from the Multi-series example. We have done the following changes in this data (saved as CDYData.xml) :
The parentYAxis attribute allows you to set the parent axis of the dataset. The required value can be either P (primary axis) or S (secondary axis). Primary datasets are drawn against the left y-axis and the secondary against the right y-axis. For more details please go through FusionCharts XT Data Format > XML > Combination Chart page. The SWF file used to render this chart is MSCombiDY2D.swf and the HTML code used is as follows: | ||||||||||||||||||||||||
Call renderChart("../../FusionCharts/MSCombiDY2D.swf", "Data/CDYData.xml", "", "myFirst", 600, 300, False, True) |
||||||||||||||||||||||||
Creating other advanced charts | ||||||||||||||||||||||||
FusionCharts XT pack offers advanced chart types like Scatter, Bubble, Multi-series Stacked, Pareto, Marimekko, etc. which can be also created using the same method described above. All you will need to do is to follow the XML format of the required chart type and use the proper SWF name of that chart type while rendering the chart. The following list provides links to the XML API pages of all the advanced chart types: |
||||||||||||||||||||||||