$this->settings["sql"] = "select OPPSN, opp0006f as Total from opp000ds where OPPSN ='".$OPPSN."'" ;
// label column name
$this->settings["xAxis"] = "OPPSN";
// data column name
$this->settings["yAxis"] = "Total";
// chart type ( column, line, bar, bar3d, pie )
$this->settings["type"] = "bar";
// title
$this->settings["title"] = "OPPSN";;