ChartDirector 6.0 (ASP/COM/VB Edition)

Data Table (1)




This example demonstrates putting a data table under the x-axis.

In ChartDirector, the labels in a label based x-axis (that is, axis configured with Axis.setLabels or Axis.setLabels2) can be converted to a table using Axis.makeLabelTable.

Note: Axis.makeLabelTable is only supported on a label based axis with no label stepping. You should not use this method with other axis configuration.


The Axis.makeLabelTable returns a CDMLTable object representing the table. It can be used to add more content to the table and to configure the appearance of the table.

In this example, 3 rows with alternating background colors are added to the table using CDMLTable.appendRow. The cells in the rows are filled with data values using CDMLTable.setText. A column is added to the left of the table using CDMLTable.insertCol, and filled with the legend icons obtained using Layer.getLegendIcon.

Source Code Listing

[Web Version (in ASP)] aspdemo\datatable.asp
<%@ language="vbscript" %>
<%
Set cd = CreateObject("ChartDirector.API")

' The data for the line chart
data0 = Array(42, 49, 33, 38, 64, 56, 29, 41, 44, 57, 59, 42)
data1 = Array(65, 75, 47, 34, 42, 49, 73, 62, 90, 69, 66, 78)
data2 = Array(36, 28, 25, 28, 38, 20, 22, 30, 25, 33, 30, 24)
labels = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", "Dec")

' Create a XYChart object of size 600 x 400 pixels
Set c = cd.XYChart(600, 400)

' Add a title to the chart using 18pt Times Bold Italic font
Set title = c.addTitle("Product Line Global Revenue", "timesbi.ttf", 18)

' Tentatively set the plotarea at (50, 55) and of (chart_width - 100) x (chart_height - 120) pixels
' in size. Use a vertical gradient color from sky blue (aaccff) t0 light blue (f9f9ff) as
' background. Set both horizontal and vertical grid lines to dotted semi-transprent black
' (aa000000).
Set plotArea = c.setPlotArea(50, 55, c.getWidth() - 100, c.getHeight() - 120, _
    c.linearGradientColor(0, 55, 0, 55 + c.getHeight() - 120, &Haaccff, &Hf9fcff), -1, -1, _
    c.dashLineColor(&Haa000000, cd.DotLine), -1)

' Add a legend box and anchored the top center at the horizontal center of the chart, just under the
' title. Use 10pt Arial Bold as font, with transparent background and border.
Set legendBox = c.addLegend(c.getWidth() / 2, title.getHeight(), False, "arialbd.ttf", 10)
Call legendBox.setAlignment(cd.TopCenter)
Call legendBox.setBackground(cd.Transparent, cd.Transparent)

' Set y-axis title using 10 points Arial Bold Italic font, label style to 8 points Arial Bold, and
' axis color to transparent
Call c.yAxis().setTitle("Revenue (USD millions)", "arialbi.ttf", 10)
Call c.yAxis().setLabelStyle("arialbd.ttf", 8)
Call c.yAxis().setColors(cd.Transparent)

' Set y-axis tick density to 30 pixels. ChartDirector auto-scaling will use this as the guideline
' when putting ticks on the y-axis.
Call c.yAxis().setTickDensity(30)

' Add a line layer to the chart
Set layer = c.addLineLayer2()

' Set the line width to 3 pixels
Call layer.setLineWidth(3)

' Add the three data sets to the line layer, using circles, diamands and X shapes as symbols
Call layer.addDataSet(data0, &Hff0000, "Quantum Computer").setDataSymbol(cd.CircleSymbol, 9)
Call layer.addDataSet(data1, &H00ff00, "Atom Synthesizer").setDataSymbol(cd.DiamondSymbol, 11)
Call layer.addDataSet(data2, &Hff6600, "Proton Cannon").setDataSymbol(cd.Cross2Shape(), 11)

' Set the x axis labels
Call c.xAxis().setLabels(labels)

' Convert the labels on the x-axis to a CDMLTable
Set table = c.xAxis().makeLabelTable()

' Set the default top/bottom margins of the cells to 3 pixels
Call table.getStyle().setMargin2(0, 0, 3, 3)

' Use Arial Bold as the font for the first row
Call table.getRowStyle(0).setFontStyle("arialbd.ttf")

'
' We can add more information to the table. In this sample code, we add the data series and the
' legend icons to the table.
'

' Add 3 more rows to the table. Set the background of the 1st and 3rd rows to light grey (eeeeee).
Call table.appendRow().setBackground(&Heeeeee, cd.LineColor)
Call table.appendRow()
Call table.appendRow().setBackground(&Heeeeee, cd.LineColor)

' Put the values of the 3 data series to the cells in the 3 rows
For i = 0 To UBound(data0)
    Call table.setText(i, 1, CStr(data0(i)))
    Call table.setText(i, 2, CStr(data1(i)))
    Call table.setText(i, 3, CStr(data2(i)))
Next

' Insert a column on the left for the legend icons. Use 5 pixels left/right margins and 3 pixels
' top/bottom margins for the cells in this column.
Call table.insertCol(0).setMargin2(5, 5, 3, 3)

' The top cell is set to transparent, so it is invisible
Call table.getCell(0, 0).setBackground(cd.Transparent, cd.Transparent)

' The other 3 cells are set to the legend icons of the 3 data series
Call table.setText(0, 1, layer.getLegendIcon(0))
Call table.setText(0, 2, layer.getLegendIcon(1))
Call table.setText(0, 3, layer.getLegendIcon(2))

' Layout legend box first, so we can get its size
Call c.layoutLegend()

' Adjust the plot area size, such that the bounding box (inclusive of axes) is 2 pixels from the
' left, right and bottom edge, and is just under the legend box.
Call c.packPlotArea(2, legendBox.getTopY() + legendBox.getHeight(), c.getWidth() - 3, c.getHeight( _
    ) - 3)

' After determining the exact plot area position, we may adjust the legend box and the title
' positions so that they are centered relative to the plot area (instead of the chart)
Call legendBox.setPos(plotArea.getLeftX() + (plotArea.getWidth() - legendBox.getWidth()) / 2, _
    legendBox.getTopY())
Call title.setPos(plotArea.getLeftX() + (plotArea.getWidth() - title.getWidth()) / 2, _
    title.getTopY())

' Output the chart
Response.ContentType = "image/png"
Response.BinaryWrite c.makeChart2(cd.PNG)
Response.End
%>

[Windows Version (in Visual Basic)] vbdemo\datatable.cls
Public Sub createChart(viewer As Object, chartIndex As Integer)

    Dim cd As New ChartDirector.API

    ' The data for the line chart
    Dim data0()
    data0 = Array(42, 49, 33, 38, 64, 56, 29, 41, 44, 57, 59, 42)
    Dim data1()
    data1 = Array(65, 75, 47, 34, 42, 49, 73, 62, 90, 69, 66, 78)
    Dim data2()
    data2 = Array(36, 28, 25, 28, 38, 20, 22, 30, 25, 33, 30, 24)
    Dim labels()
    labels = Array("Jan", "Feb", "Mar", "Apr", "May", "Jun", "Jul", "Aug", "Sep", "Oct", "Nov", _
        "Dec")

    ' Create a XYChart object of size 600 x 400 pixels
    Dim c As XYChart
    Set c = cd.XYChart(600, 400)

    ' Add a title to the chart using 18pt Times Bold Italic font
    Dim title As ChartDirector.TextBox
    Set title = c.addTitle("Product Line Global Revenue", "timesbi.ttf", 18)

    ' Tentatively set the plotarea at (50, 55) and of (chart_width - 100) x (chart_height - 120)
    ' pixels in size. Use a vertical gradient color from sky blue (aaccff) t0 light blue (f9f9ff) as
    ' background. Set both horizontal and vertical grid lines to dotted semi-transprent black
    ' (aa000000).
    Dim plotArea As PlotArea
    Set plotArea = c.setPlotArea(50, 55, c.getWidth() - 100, c.getHeight() - 120, _
        c.linearGradientColor(0, 55, 0, 55 + c.getHeight() - 120, &Haaccff, &Hf9fcff), -1, -1, _
        c.dashLineColor(&Haa000000, cd.DotLine), -1)

    ' Add a legend box and anchored the top center at the horizontal center of the chart, just under
    ' the title. Use 10pt Arial Bold as font, with transparent background and border.
    Dim legendBox As LegendBox
    Set legendBox = c.addLegend(c.getWidth() / 2, title.getHeight(), False, "arialbd.ttf", 10)
    Call legendBox.setAlignment(cd.TopCenter)
    Call legendBox.setBackground(cd.Transparent, cd.Transparent)

    ' Set y-axis title using 10 points Arial Bold Italic font, label style to 8 points Arial Bold,
    ' and axis color to transparent
    Call c.yAxis().setTitle("Revenue (USD millions)", "arialbi.ttf", 10)
    Call c.yAxis().setLabelStyle("arialbd.ttf", 8)
    Call c.yAxis().setColors(cd.Transparent)

    ' Set y-axis tick density to 30 pixels. ChartDirector auto-scaling will use this as the
    ' guideline when putting ticks on the y-axis.
    Call c.yAxis().setTickDensity(30)

    ' Add a line layer to the chart
    Dim layer As LineLayer
    Set layer = c.addLineLayer2()

    ' Set the line width to 3 pixels
    Call layer.setLineWidth(3)

    ' Add the three data sets to the line layer, using circles, diamands and X shapes as symbols
    Call layer.addDataSet(data0, &Hff0000, "Quantum Computer").setDataSymbol(cd.CircleSymbol, 9)
    Call layer.addDataSet(data1, &H00ff00, "Atom Synthesizer").setDataSymbol(cd.DiamondSymbol, 11)
    Call layer.addDataSet(data2, &Hff6600, "Proton Cannon").setDataSymbol(cd.Cross2Shape(), 11)

    ' Set the x axis labels
    Call c.xAxis().setLabels(labels)

    ' Convert the labels on the x-axis to a CDMLTable
    Dim table As CDMLTable
    Set table = c.xAxis().makeLabelTable()

    ' Set the default top/bottom margins of the cells to 3 pixels
    Call table.getStyle().setMargin2(0, 0, 3, 3)

    ' Use Arial Bold as the font for the first row
    Call table.getRowStyle(0).setFontStyle("arialbd.ttf")

    '
    ' We can add more information to the table. In this sample code, we add the data series and the
    ' legend icons to the table.
    '

    ' Add 3 more rows to the table. Set the background of the 1st and 3rd rows to light grey
    ' (eeeeee).
    Call table.appendRow().setBackground(&Heeeeee, cd.LineColor)
    Call table.appendRow()
    Call table.appendRow().setBackground(&Heeeeee, cd.LineColor)

    ' Put the values of the 3 data series to the cells in the 3 rows
    Dim i As Long
    For i = 0 To UBound(data0)
        Call table.setText(i, 1, CStr(data0(i)))
        Call table.setText(i, 2, CStr(data1(i)))
        Call table.setText(i, 3, CStr(data2(i)))
    Next

    ' Insert a column on the left for the legend icons. Use 5 pixels left/right margins and 3 pixels
    ' top/bottom margins for the cells in this column.
    Call table.insertCol(0).setMargin2(5, 5, 3, 3)

    ' The top cell is set to transparent, so it is invisible
    Call table.getCell(0, 0).setBackground(cd.Transparent, cd.Transparent)

    ' The other 3 cells are set to the legend icons of the 3 data series
    Call table.setText(0, 1, layer.getLegendIcon(0))
    Call table.setText(0, 2, layer.getLegendIcon(1))
    Call table.setText(0, 3, layer.getLegendIcon(2))

    ' Layout legend box first, so we can get its size
    Call c.layoutLegend()

    ' Adjust the plot area size, such that the bounding box (inclusive of axes) is 2 pixels from the
    ' left, right and bottom edge, and is just under the legend box.
    Call c.packPlotArea(2, legendBox.getTopY() + legendBox.getHeight(), c.getWidth() - 3, _
        c.getHeight() - 3)

    ' After determining the exact plot area position, we may adjust the legend box and the title
    ' positions so that they are centered relative to the plot area (instead of the chart)
    Call legendBox.setPos(plotArea.getLeftX() + (plotArea.getWidth() - legendBox.getWidth()) / 2, _
        legendBox.getTopY())
    Call title.setPos(plotArea.getLeftX() + (plotArea.getWidth() - title.getWidth()) / 2, _
        title.getTopY())

    ' Output the chart
    Set viewer.Picture = c.makePicture()

    'include tool tip for the chart
    viewer.ImageMap = c.getHTMLImageMap("clickable", "", _
        "title='Revenue of {dataSetName} in {xLabel}: US$ {value}M'")

End Sub