ChartDirector 7.0 (PHP 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

[File: phpdemo/datatable.php]
<?php
require_once("../lib/phpchartdir.php");

# 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
$c = new XYChart(600, 400);

# Add a title to the chart using 18pt Times Bold Italic font
$title = $c->addTitle("Product Line Global Revenue", "Times New Roman Bold Italic", 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).
$plotArea = $c->setPlotArea(50, 55, $c->getWidth() - 100, $c->getHeight() - 120,
    $c->linearGradientColor(0, 55, 0, 55 + $c->getHeight() - 120, 0xaaccff, 0xf9fcff), -1, -1,
    $c->dashLineColor(0xaa000000, 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.
$legendBox = $c->addLegend($c->getWidth() / 2, $title->getHeight(), false, "Arial Bold", 10);
$legendBox->setAlignment(TopCenter);
$legendBox->setBackground(Transparent, Transparent);

# Set y-axis title using 10 points Arial Bold Italic font, label style to 8 points Arial Bold, and
# axis color to transparent
$c->yAxis->setTitle("Revenue (USD millions)", "Arial Bold Italic", 10);
$c->yAxis->setLabelStyle("Arial Bold", 8);
$c->yAxis->setColors(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.
$c->yAxis->setTickDensity(30);

# Add a line layer to the chart
$layer = $c->addLineLayer2();

# Set the line width to 3 pixels
$layer->setLineWidth(3);

# Add the three data sets to the line layer, using circles, diamands and X shapes as symbols
$layer->addDataSet($data0, 0xff0000, "Quantum Computer")->setDataSymbol(CircleSymbol, 9);
$layer->addDataSet($data1, 0x00ff00, "Atom Synthesizer")->setDataSymbol(DiamondSymbol, 11);
$layer->addDataSet($data2, 0xff6600, "Proton Cannon")->setDataSymbol(Cross2Shape(), 11);

# Set the x axis labels
$c->xAxis->setLabels($labels);

# Convert the labels on the x-axis to a CDMLTable
$table = $c->xAxis->makeLabelTable();

# Set the default top/bottom margins of the cells to 3 pixels
$table->getStyle()->setMargin2(0, 0, 3, 3);

# Use Arial Bold as the font for the first row
$table->getRowStyle(0)->setFontStyle("Arial Bold");

#
# 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).
$table->appendRow()->setBackground(0xeeeeee, LineColor);
$table->appendRow();
$table->appendRow()->setBackground(0xeeeeee, LineColor);

# Put the values of the 3 data series to the cells in the 3 rows
for($i = 0; $i < count($data0); ++$i) {
    $table->setText($i, 1, $data0[$i]);
    $table->setText($i, 2, $data1[$i]);
    $table->setText($i, 3, $data2[$i]);
}

# 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.
$table->insertCol(0)->setMargin2(5, 5, 3, 3);

# The top cell is set to transparent, so it is invisible
$table->getCell(0, 0)->setBackground(Transparent, Transparent);

# The other 3 cells are set to the legend icons of the 3 data series
$table->setText(0, 1, $layer->getLegendIcon(0));
$table->setText(0, 2, $layer->getLegendIcon(1));
$table->setText(0, 3, $layer->getLegendIcon(2));

# Layout legend box first, so we can get its size
$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.
$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)
$legendBox->setPos($plotArea->getLeftX() + ($plotArea->getWidth() - $legendBox->getWidth()) / 2,
    $legendBox->getTopY());
$title->setPos($plotArea->getLeftX() + ($plotArea->getWidth() - $title->getWidth()) / 2,
    $title->getTopY());

# Output the chart
$viewer = new WebChartViewer("chart1");
$viewer->setChart($c, SVG);

# Include tool tip for the chart
$viewer->setImageMap($c->getHTMLImageMap("", "",
    "title='Revenue of {dataSetName} in {xLabel}: US\$ {value}M'"));
?>

<!DOCTYPE html>
<html>
<head>
    <title>Data Table (1)</title>
    <!-- Include ChartDirector Javascript Library to support chart interactions -->
    <script type="text/javascript" src="cdjcv.js"></script>
</head>
<body style="margin:5px 0px 0px 5px">
    <div style="font:bold 18pt verdana;">
        Data Table (1)
    </div>
    <hr style="border:solid 1px #000080; background:#000080" />
    <div style="font:10pt verdana; margin-bottom:1.5em">
        <a href="viewsource.php?file=<?=basename(__FILE__)?>">View Chart Source Code</a>
    </div>
    <!-- ****** Here is the chart image ****** -->
    <?php echo $viewer->renderHTML(); ?>
</body>
</html>