aspose.cells
Class ChartDataTable

Represents a chart data table.

Example:

//Instantiating a Workbook object
$workbook = new cells\Workbook();
//Obtaining the reference of the first worksheet
$worksheet = $workbook->getWorksheets()->get(0);
//Adding a sample value to "A1" cell
$worksheet->getCells()->get("A1")->putValue(50);
//Adding a sample value to "A2" cell
$worksheet->getCells()->get("A2")->putValue(100);
//Adding a sample value to "A3" cell
$worksheet->getCells()->get("A3")->putValue(150);
//Adding a sample value to "B1" cell
$worksheet->getCells()->get("B1")->putValue(60);
//Adding a sample value to "B2" cell
$worksheet->getCells()->get("B2")->putValue(32);
//Adding a sample value to "B3" cell
$worksheet->getCells()->get("B3")->putValue(50);
//Adding a chart to the worksheet
$chartIndex = $worksheet->getCharts()->add(cells\ChartType::COLUMN, 5, 0, 25, 10);
//Accessing the instance of the newly added chart
$chart = $worksheet->getCharts()->get($chartIndex);
//Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
$chart->getNSeries()->add("A1:B3", true);
$chart->setDataTableShown(true);
//Getting Chart Table
$chartTable = $chart->getChartDataTable();
//Setting Chart Table Font Color
$chartTable->getFont()->setColor(cells\Color::getRed());
//Setting Legend Key Visibility
$chartTable->setShowLegendKey(false);

Property Getters/Setters Summary
functiongetAutoScaleFont()
functionsetAutoScaleFont(value)
           True if the text in the object changes font size when the object size changes. The default value is True.
functiongetBackground()
functionsetBackground(value)
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
functiongetBackgroundMode()
functionsetBackgroundMode(value)
           Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.
functiongetBorder()
           Returns a Border object that represents the border of the object
functiongetFont()
           Gets a Font object which represents the font setting of the specified chart data table.
functionhasBorderHorizontal()
functionsetHasBorderHorizontal(value)
           True if the chart data table has horizontal cell borders
functionhasBorderOutline()
functionsetHasBorderOutline(value)
           True if the chart data table has outline borders
functionhasBorderVertical()
functionsetHasBorderVertical(value)
           True if the chart data table has vertical cell borders
functiongetShowLegendKey()
functionsetShowLegendKey(value)
           True if the data label legend key is visible.
 

Property Getters/Setters Detail

getFont : Font 

function getFont()
Gets a Font object which represents the font setting of the specified chart data table.

getAutoScaleFont/setAutoScaleFont : boolean 

function getAutoScaleFont() / function setAutoScaleFont(value)
True if the text in the object changes font size when the object size changes. The default value is True.

getBackgroundMode/setBackgroundMode : Number 

function getBackgroundMode() / function setBackgroundMode(value)
Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.

getBackground/setBackground : Number 

function getBackground() / function setBackground(value)
Gets and sets the display mode of the background The value of the property is BackgroundMode integer constant.NOTE: This member is now obsolete. Instead, please use ChartDataTable.BackgroundMode property. This property will be removed 12 months later since JANUARY 2012. Aspose apologizes for any inconvenience you may have experienced.

hasBorderHorizontal/setHasBorderHorizontal : boolean 

function hasBorderHorizontal() / function setHasBorderHorizontal(value)
True if the chart data table has horizontal cell borders

hasBorderVertical/setHasBorderVertical : boolean 

function hasBorderVertical() / function setHasBorderVertical(value)
True if the chart data table has vertical cell borders

hasBorderOutline/setHasBorderOutline : boolean 

function hasBorderOutline() / function setHasBorderOutline(value)
True if the chart data table has outline borders

getShowLegendKey/setShowLegendKey : boolean 

function getShowLegendKey() / function setShowLegendKey(value)
True if the data label legend key is visible.

getBorder : Line 

function getBorder()
Returns a Border object that represents the border of the object

See Also:
          Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
          Aspose.Cells Support Forum - our preferred method of support.