Scope of our dynamic charts and the basic setup
In this chapter, we will use three common server-side scripting languages—PHP, ASP.NET using C#, and JSP. In each of these languages, we will create the following dynamic charts:
As our simplest example, we will create a chart using data stored in arrays. This will help you understand how to convert data dynamically to XML. We will compare the Sales of Food Products to Non-Food Products in this chart.
Next, we will build the same from the data stored in a sample database. In this chart, we will replicate the annual revenue that we had earlier built, but this time the data will come from a database. We will use a simple database for this, as explained in the following section.
Finally, we will add drill-down capabilities to the previously created chart to allow Harry to drill-down from annual revenues to quarterly revenues.