<?php include_once 'Google.merge.v_1_0.php'; // main $v = new Google_Visualization("Table_Format"); // config $c = new Google_Config("Table"); $c->setProperty("allowHtml", true); // format $f = Google_Format::factory("Bar"); $f->min = -10000; $f->max = 10000; $f->drawZeroLine = true; $f->colorNegative = 'red'; $f->showValue = false; $f->width = 250; $f->format("data", 1); $c->setProperty("showRowNumber", true); // data $o = new Google_Data_Base(); $o->addColumn("0", "Country", "string"); $o->addColumn("1", "Sales", "number"); $o->addColumn("2", "Expenses", "number"); $o->addNewRow(); $o->addStringCellToRow("US"); $o->addNumberCellToRow(10000); $o->addNumberCellToRow(8000); $o->addNewRow(); $o->addStringCellToRow("CA"); $o->addNumberCellToRow(-7000); $o->addNumberCellToRow(5000);
<?php include_once 'Google.merge.v_1_0.php'; // main $v = new Google_Visualization("Table_Format"); // config $c = new Google_Config("Table"); $c->setProperty("allowHtml", true); // format $f = Google_Format::factory("Arrow"); $f->format("data", 1); $c->setProperty("showRowNumber", true); // data $o = Google_Data::getInstance()->getDataObject(); $o->addColumn("0", "Department", "string"); $o->addColumn("1", "Revenues Change", "number"); $o->addNewRow(); $o->addStringCellToRow("Shoes"); $o->addNumberCellToRow(-5.4); $o->addNewRow(); $o->addStringCellToRow("Sports"); $o->addNumberCellToRow(12.5); $o->addNewRow(); $o->addStringCellToRow("Toys"); $o->addNumberCellToRow(21.2); $o->addNewRow(); $o->addStringCellToRow("Food"); $o->addNumberCellToRow(24.2); $v->setConfig($c); $v->setData($o); $v->setFormat($f);
<?php include_once 'Google.merge.v_1_0.php'; // main $v = new Google_Visualization("Table_Format"); // config $c = new Google_Config("Table"); $c->setProperty("allowHtml", true); // format $f = Google_Format::factory("Color"); $f->addRange(-10, 0, 'red', 'orange'); $f->addRange(10, 20, 'green', 'yellow'); $f->format("data", 1); $c->setProperty("showRowNumber", true); // data $o = Google_Data::getInstance()->getDataObject(); $o->addColumn("0", "Department", "string"); $o->addColumn("1", "Revenues", "number"); $o->addNewRow(); $o->addStringCellToRow("Shoes"); $o->addNumberCellToRow(-5.4); $o->addNewRow(); $o->addStringCellToRow("Sports"); $o->addNumberCellToRow(12.5); $o->addNewRow(); $o->addStringCellToRow("Toys"); $o->addNumberCellToRow(21.2); $o->addNewRow(); $o->addStringCellToRow("Food"); $o->addNumberCellToRow(24.2); $v->setConfig($c);
<?php include_once 'Google.merge.v_1_0.php'; // main $v = new Google_Visualization("Table_Format"); // config $c = new Google_Config("Table"); $c->setProperty("allowHtml", true); // format $f = Google_Format::factory("Number"); $f->prefix = '€'; $f->negativeColor = 'red'; $f->negativeParens = true; $f->format("data", 1); $c->setProperty("showRowNumber", true); // data $o = Google_Data::getInstance()->getDataObject(); $o->addColumn("0", "Department", "string"); $o->addColumn("1", "Revenues", "number"); $o->addNewRow(); $o->addStringCellToRow("Shoes"); $o->addNumberCellToRow(-5.4); $o->addNewRow(); $o->addStringCellToRow("Sports"); $o->addNumberCellToRow(12.5); $o->addNewRow(); $o->addStringCellToRow("Toys"); $o->addNumberCellToRow(21.2); $o->addNewRow(); $o->addStringCellToRow("Food"); $o->addNumberCellToRow(24.2);
<?php include_once 'Google.merge.v_1_0.php'; // main $v = new Google_Visualization("Table_Format"); // config $c = new Google_Config("Table"); $c->setProperty("allowHtml", true); // format $f = Google_Format::factory("Date"); $f->formatType("short"); // medium|long $f->format("data", 1); $c->setProperty("showRowNumber", true); // data $o = Google_Data::getInstance()->getDataObject(); $o->addColumn("0", "Employee", "string"); $o->addColumn("1", "since", "date"); $o->addNewRow(); $o->addStringCellToRow("Mike"); $o->addDateCellToRow(2001, 10, 1); $o->addNewRow(); $o->addStringCellToRow("Luke"); $o->addDateCellToRow(2002, 1, 1); $o->addNewRow(); $o->addStringCellToRow("Carl"); $o->addDateCellToRow(2002, 6, 1); $o->addNewRow(); $o->addStringCellToRow("Tom"); $o->addDateCellToRow(2009, 6, 1); $v->setConfig($c);
<?php include_once 'Google.merge.v_1_0.php'; // main $v = new Google_Visualization("Table_Format"); // config $c = new Google_Config("Table"); $c->setProperty("allowHtml", true); $c->setProperty("showRowNumber", true); // format $f = Google_Format::factory("Pattern"); $f->pattern('<a href="mailto:{1}">{0}</a>'); $f->format("data", array(0, 1)); // data view $d = new Google_Data_View(); $d->setColumns(array(0)); // data $o = Google_Data::getInstance()->getDataObject(); $o->addColumn("0", "Name", "string"); $o->addColumn("1", "Email", "string"); $o->addNewRow(); $o->addStringCellToRow("Tom"); $o->addStringCellToRow("*****@*****.**"); $o->addNewRow(); $o->addStringCellToRow("Mike"); $o->addStringCellToRow("*****@*****.**"); $v->setConfig($c); $v->setData($o); $v->setFormat($f); $v->setDataView($d); ?>