Barchart

[Semjasa]

Hey,
i want to build an column or barchart with different colors per bar is there a way to colorize each bar.

[Betsy.jiang]

Hi,

Thanks for your inquiry.
Please refer to following code:

Code: Select all

            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);

Any question, welcome to get it back to us.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Hope you are doing well.
Does the code I provided help you solve your issue? Could you please give us some feedback at your convenience?

Sincerely,
Betsy
E-iceblue support team

[Semjasa]

Sorry for this late post.

THX this works amazing

Thomas

[Jane.Bai]

Hi,

Thank you for your feedback!
Just feel free to contact us if you need any assistance!

Sincerely,
Jane
E-iceblue support team