Column Chart

OrderIDUnitPriceQty
10348 21.6 40
10365 16.8 24
10367 44.3 76
10375 24.5 25
10380 86.1 74
10390 61.8 169
10394 44.2 20
10400 129.4 86
10405 8 50
10415 33.2 22

bottom next goreload

[1 - 10 : 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