Class ChartDataTable

ChartDataTable class

Represents a chart data table.

public class ChartDataTable

Properties

NameDescription
AutoScaleFont { get; set; }True if the text in the object changes font size when the object size changes. The default value is True.
BackgroundMode { get; set; }Gets and sets the display mode of the background
Border { get; }Returns a Border object that represents the border of the object
Font { get; }Gets a Font object which represents the font setting of the specified chart data table.
HasBorderHorizontal { get; set; }(Obsolete.) True if the chart data table has horizontal cell borders
HasBorderOutline { get; set; }(Obsolete.) True if the chart data table has outline borders
HasBorderVertical { get; set; }(Obsolete.) True if the chart data table has vertical cell borders
HasHorizontalBorder { get; set; }True if the chart data table has horizontal cell borders
HasOutlineBorder { get; set; }True if the chart data table has outline borders
HasVerticalBorder { get; set; }True if the chart data table has vertical cell borders
ShowLegendKey { get; set; }True if the data label legend key is visible.

Examples

namespace AsposeCellsExamples
{
    using Aspose.Cells;
    using Aspose.Cells.Charts;
    using System;
    using System.Drawing;

    public class ChartDataTableDemo
    {
        public static void ChartDataTableExample()
        {
            // Instantiating a Workbook object
            Workbook workbook = new Workbook();

            // Obtaining the reference of the first worksheet
            Worksheet worksheet = workbook.Worksheets[0];

            // Adding sample values to cells
            worksheet.Cells["A1"].PutValue(50);
            worksheet.Cells["A2"].PutValue(100);
            worksheet.Cells["A3"].PutValue(150);
            worksheet.Cells["B1"].PutValue(60);
            worksheet.Cells["B2"].PutValue(32);
            worksheet.Cells["B3"].PutValue(50);

            // Adding a chart to the worksheet
            int chartIndex = worksheet.Charts.Add(ChartType.Column, 5, 0, 25, 10);

            // Accessing the instance of the newly added chart
            Chart chart = worksheet.Charts[chartIndex];

            // Adding NSeries (chart data source) to the chart ranging from "A1" cell to "B3"
            chart.NSeries.Add("A1:B3", true);

            // Displaying the data table
            chart.ShowDataTable = true;

            // Getting Chart Data Table
            ChartDataTable chartTable = chart.ChartDataTable;

            // Setting Chart Data Table properties
            chartTable.Font.Color = Color.Red;
            chartTable.AutoScaleFont = true;
            chartTable.BackgroundMode = BackgroundMode.Transparent;
            chartTable.HasBorderHorizontal = true;
            chartTable.HasBorderVertical = true;
            chartTable.HasBorderOutline = true;
            chartTable.ShowLegendKey = false;

            // Saving the Excel file
            workbook.Save("ChartDataTableExample.xlsx");
            workbook.Save("ChartDataTableExample.pdf");
        }
    }
}

See Also