Define Area chart for GridChart or standalone mode.
Mydb.dbAreaChart = "Label| Name| Y|...Name39| Y39"
| Keyword | Description |
|---|---|
| Label | FieldNameOrNumber providing the X-axis labels. |
| Name | Name of Line used by Legends. |
| Y | FieldNameOrNumber providing the Y-axis dataset (0-39) values. |
Overide the values with dbChartParams.
This example creates a csv file with one label and 2 datasets, save to scratch directory and then open it as csv datasource with 3 columns - F1, F2 and F3. F1 is the label-axis and F2, F3 are the two datasets. The dbAreaChart will plot the two areas with default settings. A third line is created manually in dbChartParams with it's own settings.
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
Dim CSV As String = "F1,F2,F3,F4,F5,F6" & vbCrLf & "-5,0,50,0,80,80" & vbCrLf & _
"0,-200,200,8,100,70" & vbCrLf & "-5,250,150,3,300,150"
Dim util As New Tornado.Util
util.WriteFile("c:\inetpub\wwwroot\tornado\scratch\TestBubble.Csv", CSV)
Dim Area As New Tornado.z
With Area
.dbQP = "U=5| S=oceanbelow| PS=-1| Ni=none| M=Gc| Q=Select * From TestBubble.Csv| Dt=TEXT| Pv=OLEDB"
.dbDSN = "/tornado/scratch"
Dim Bc As String = "Name0=Bubble Zero| X0=#0#| Y0=#1#| S0=#2#| Name1=Bubble One| X1=#3#| Y1=#4#| S1=#5#|"
Bc &= "Name2=My Bubble| X2=-7,-5,7| Y2=6,-200,-150| S2=100,150,100|leg=f"
.dbBubbleChart = Bc
.dbTextHolder = "Title=Bubble Chart"
.ASPdbNET()
End With
End Sub
</script>
z Class | Tornado Namespace | dbPieChart | dbBarChart | dbColumnChart | dbLineChart | dbDateLineChart | dbAreaChart | Special Topic - Charting