Barchart with Target-Line

[Semjasa]

Hey again,

i have again an question about creating barcharts. Is there a way to create a target-line for every series in my barchart just like this image but this line is from datapoint to datapoint different

a little bit like stairs (up and down)

2019-01-08_12h06_59.png (6.3 KiB) Viewed 842 times

THX

Thomas

[Betsy.jiang]

Hi Thomas,

Thanks for your inquiry.
According to your information, I think that the error bar could meet your requirement. After testing, I find the data labels of series 2 is unable to set as invisible. I have posted this issue to our Dev team, we will let you know as soon as there is any update.
Below is my testing code, and attached are my files for your reference:

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"F:\testing\xls test form\sample document\target line.xlsx");
            Worksheet sheet = workbook.Worksheets[0];

            //Add Chart and Set Chart Data Range
            Chart chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);
            chart.DataRange = sheet.Range["A1:C5"];
            chart.SeriesDataFromRange = false;
            chart.PrimaryValueAxis.HasMajorGridLines = false;

            //Chart Position
            chart.LeftColumn = 1;
            chart.TopRow = 19;
            chart.RightColumn = 15;
            chart.BottomRow = 40;

            ChartSerie ser2 = chart.Series[1];
            //this code doesn't work
            ser2.DataPoints.DefaultDataPoint.DataLabels.HasValue = false;
            ser2.UsePrimaryAxis = true;
            //For adding error bar X, change the chart type as scatter marker.
            ser2.SerieType = ExcelChartType.ScatterMarkers;
            ser2.Format.MarkerStyle = ChartMarkerType.None;
           

            //add the error bar X for the serie
            var eb = ser2.ErrorBar(false,ErrorBarIncludeType.Both);
            eb.HasCap = false;
            eb.Border.Color = Color.Red;
            eb.Border.Weight = ChartLineWeightType.Medium;
            eb.NumberValue = 0.3;

            workbook.SaveToFile("CreatErrorBar16072.xlsx",ExcelVersion.Version2013);

Sincerely,
Betsy
E-iceblue support team

[Semjasa]

THIS IS AMAZING!!!

Thank you this is perfect to see.

Thanks for this fast reply.

best regards
Thomas

[Betsy.jiang]

Hi Thomas,

I will inform you once the issue I mentioned is fixed.

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi Thomas,

After further investigation, we found the reason of the issue I mentioned before. When using the code "ser2.SerieType = ExcelChartType.ScatterMarkers", all settings of datapoints in that series would be clear, so you need to set the corresponding code after above code. Here is changed code for your kind reference:

Code: Select all

            Workbook workbook = new Workbook();
            workbook.LoadFromFile(@"F:\testing\xls test form\sample document\target line.xlsx");
            Worksheet sheet = workbook.Worksheets[0];

            //Add Chart and Set Chart Data Range
            Chart chart = sheet.Charts.Add(ExcelChartType.ColumnClustered);
            chart.DataRange = sheet.Range["A1:C5"];
            chart.SeriesDataFromRange = false;
            chart.PrimaryValueAxis.HasMajorGridLines = false;

            //Chart Position
            chart.LeftColumn = 1;
            chart.TopRow = 19;
            chart.RightColumn = 15;
            chart.BottomRow = 40;

            ChartSerie ser2 = chart.Series[1];

            ser2.UsePrimaryAxis = true;
            //For adding error bar X, change the chart type as scatter marker.
            ser2.SerieType = ExcelChartType.ScatterMarkers;
            ser2.Format.MarkerStyle = ChartMarkerType.None;
            //change the position
            ser2.DataPoints.DefaultDataPoint.DataLabels.HasValue = false;
            //set the series name as invisible
            ser2.DataPoints.DefaultDataPoint.DataLabels.HasSeriesName = false;
            //set the category name as invisible
            ser2.DataPoints.DefaultDataPoint.DataLabels.HasCategoryName = false;

            //add the error bar X for the serie
            var eb = ser2.ErrorBar(false,ErrorBarIncludeType.Both);
            eb.HasCap = false;
            eb.Border.Color = Color.Red;
            eb.Border.Weight = ChartLineWeightType.Medium;
            eb.NumberValue = 0.3;

            workbook.SaveToFile("CreatErrorBar16072.xlsx",ExcelVersion.Version2013);

Sincerely,
Betsy
E-iceblue support team

[Betsy.jiang]

Hi,

Greetings from E-iceblue.
Did the code I provided help you solve your issue?
Could you please give us some feedback at your convenience?

Best wishes,
Betsy
E-iceblue support team

[Semjasa]

entschuldigen sie bitte. ich habe im alltag einfach vergessen zu antworten. Es funktionert wunderbar wie alle dinge die man fragt.

Amazing Support!!!

Thanks a lot

Thomas

[Betsy.jiang]

Hi Thomas,

It is my pleasure to help you.
Please feel free to contact us if you need any help.
Have a nice day!

Sincerely,
Betsy
E-iceblue support team