Column Chart

OrderIDUnitPriceQty
10418 53.6 146
10420 106.4 50
10421 68.8 59
10422 24.9 2
10423 54 34
10424 235.2 139
10425 33.6 30
10426 57 12
10429 48.1 75
10430 113.6 195

top prev bottom next goreload

[11 - 20 : 1624]

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