Column Chart

OrderIDUnitPriceQty
10430 113.6 195
10436 72.8 99
10438 34.1 50
10440 150.9 208
10441 35.1 50
10443 53.2 18
10444 78.2 63
10445 20.3 21
10446 26.5 50
10447 41.3 77

bottom next goreload

[1 - 10 : 1465]

Column Chart
<script language="VB" runat="server">
Sub Page_Load(Src As Object, E As EventArgs)
  Dim Col As New Tornado.z
  With Col
    .dbQP = "U=25| D=nwind| S=18| PS=10| M=Gc"
    .dbSQL = "SELECT OrderID, sum(UnitPrice) as UnitPrice, sum(Quantity) as Qty from [Order details] Group by OrderId"
    .dbChartParams = "xAxisLabelAngle=45|yAxisTitle=My Y-Axis Title| xAxisTitle=My X-Axis Title| yAxisOptions=rotateTitle=true"
    .dbColumnChart = "Legend=t| Label=#0#| DataSet0=#1#| DataSet1=#2#| DataSet2=27,59,51,95,92,67,100,37,56,111"
    .dbTextHolder = "Title=Column Chart"
    .ASPdbNET()
  End With
End Sub
</script>
Simplified ColumnChart - Just specify the dbColumnChart and override default parameters with dbChartParams. This example has 2 DB and 1 user column.

Send comments on this topic.
Copyright (c) 1998-2006 ASP-db