Syncfusion.XlsIO.Base
Example 


Syncfusion.XlsIO Namespace > IChartSerieDataFormat Interface : MarkerForegroundColorIndex Property

MarkerForegroundColorIndex Property (IChartSerieDataFormat)

Gets or sets the index of marker fill color from predefined colors (ExcelKnownColors).
Syntax
'Declaration
 
Property MarkerForegroundColorIndex As ExcelKnownColors
'Usage
 
Dim instance As IChartSerieDataFormat
Dim value As ExcelKnownColors
 
instance.MarkerForegroundColorIndex = value
 
value = instance.MarkerForegroundColorIndex
ExcelKnownColors MarkerForegroundColorIndex {get; set;}
Example
The following code illustrates how to set a color from ExcelKnownColors enumeration to marker applied.
using Syncfusion.XlsIO;
            
class Program
{
    static void Main(string[] args)
    {
        using (ExcelEngine excelEngine = new ExcelEngine())
        {
            //Create worksheet
            IApplication application = excelEngine.Excel;
            application.DefaultVersion = ExcelVersion.Excel2013;
            IWorkbook workbook = application.Workbooks.Create(1);
            IWorksheet sheet = workbook.Worksheets[0];
            
            //Add data
            sheet.Range["A1"].Text = "Jan";
            sheet.Range["B1"].Text = "Feb";
            sheet.Range["C1"].Text = "Mar";
            sheet.Range["A2"].Value = "10";
            sheet.Range["B2"].Value = "20";
            sheet.Range["C2"].Value = "30";
            
            //Create chart
            IChart chart = sheet.Charts.Add();
            
            //Set range
            chart.DataRange = sheet.Range["A1:C2"];
            
            //Set chart type
            chart.ChartType = ExcelChartType.Line;
            
            //Set serie format
            IChartSerieDataFormat format = chart.Series[0].SerieFormat;
            
            //Set marker style
            format.MarkerStyle = ExcelChartMarkerType.Circle;
            
            //Set color
            format.MarkerBackgroundColorIndex = ExcelKnownColors.Red;
            format.MarkerForegroundColorIndex = ExcelKnownColors.Black;
            
            //Save and Dispose
            workbook.SaveAs("Chart.xlsx");
            workbook.Close();
        }
    }
}
AssemblyVersion

Syncfusion.XlsIO.Base: 16.4460.0.40

See Also