GrapeCity.Documents.Excel.Drawing.IDataTable.Format

Format Property

Format

Gets the format of the chart data table.

Use the returned IChartFormat object to access the fill and line formatting settings of the chart data table.

Declaration

IChartFormat Format { get; }

ReadOnly Property Format As IChartFormat

Examples

worksheet.Range["A1:C3"].Value = new object[,] {
    {"Month", "Sales", "Profit"},
    {"Jan", 100, 20},
    {"Feb", 120, 25}
};
worksheet.Shapes.AddChart(ChartType.ColumnClustered, 20, 20, 300, 200)
    .Chart.SeriesCollection.Add(worksheet.Range["A1:C3"]);
worksheet.Shapes[0].Chart.HasDataTable = true;
worksheet.Shapes[0].Chart.DataTable.Format.Line.Weight = 1.5;