Hey,
i want to build an column or barchart with different colors per bar is there a way to colorize each bar.
Workbook workbook = new Workbook();
workbook.LoadFromFile(@"F:\sample.xlsx");
Worksheet sheet = workbook.Worksheets[0];
//add chart
var chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);
//set the data range
chart.DataRange = sheet.Range["A1:B2"];
chart.SeriesDataFromRange = true;
//set the different color for each bar/datapoint
chart.Series[0].DataPoints[0].DataFormat.Fill.ForeColor = Color.Red;
chart.Series[0].DataPoints[1].DataFormat.Fill.ForeColor = Color.Yellow;
chart.Series[1].DataPoints[0].DataFormat.Fill.ForeColor = Color.Blue;
chart.Series[1].DataPoints[1].DataFormat.Fill.ForeColor = Color.SkyBlue;
workbook.SaveToFile("15944.xlsx", ExcelVersion.Version2010);