Gauge Chart sample

[muthu.ramakrishnan@gs1ca.org]

Hi
Does this support Gauge chart? If so please provide a sample.

thanks

[amy.zhao]

Hello,

Thanks for your inquiry.
Our Spire.Xls supports it, please refer to the following sample code:

Code: Select all

 Workbook book = new Workbook();
            Worksheet sheet = book.Worksheets[0];
            sheet.Range["A1"].Value = "Donut";
            sheet.Range["A2"].Value = "25";
            sheet.Range["A3"].Value = "50";
            sheet.Range["A4"].Value = "25";
            sheet.Range["A5"].Value = "100";
            sheet.Range["B1"].Value = "Pie";
            sheet.Range["B2"].Value = "75";
            sheet.Range["B3"].Value = "1";
            sheet.Range["B4"].Value = "124";

            Chart chart = sheet.Charts.Add(ExcelChartType.Doughnut);
            chart.DataRange = sheet.Range["A1:B5"];
            chart.SeriesDataFromRange = false;
            chart.HasLegend = false;
            chart.LeftColumn = 1;
            chart.TopRow = 7;
            chart.RightColumn = 10;
            chart.BottomRow = 25;

            var cs1 = (ChartSerie)chart.Series["Donut"];
            cs1.Values = sheet.Range["A2:A5"];
            cs1.Format.Options.IsVaryColor = true;
            cs1.DataPoints[3].DataFormat.Fill.FillType = ShapeFillType.SolidColor;
            cs1.DataPoints[3].DataFormat.Fill.ForeColor = Color.White;
            cs1.DataFormat.Options.FirstSliceAngle = 270;

            var cs2 = (ChartSerie)chart.Series["Pie"];
            cs2.Values = sheet.Range["B2:B5"];
            cs2.SerieType = ExcelChartType.Pie;
            cs2.DataFormat.Options.FirstSliceAngle = 270;
            cs2.DataPoints[0].DataFormat.Fill.Visible = false;
            cs2.DataPoints[1].DataFormat.Fill.FillType = ShapeFillType.SolidColor;
            cs2.DataPoints[1].DataFormat.Fill.ForeColor = Color.Black;
            cs2.DataPoints[2].DataFormat.Fill.Visible = false;
            cs2.DataPoints[3].DataFormat.Fill.Visible = false;
            string fn = "AddGaugeChart.xlsx";
            book.SaveToFile(fn, FileFormat.Version2010);

Best Regards,
Amy
E-iceblue support team

[amy.zhao]

Hello,

Has your issue been solved?
Thanks for your feedback.

Best Regards,
Amy
E-iceblue support team

[muthu.ramakrishnan@gs1ca.org]

Thanks. That works.

Due to our specific request around needle shape and color ranges we took a workaround(there are only 4 possible values so we use 4 images)

[Betsy]

Hello,

Thanks for your feedback.
Please feel free to contact us if you have any question.

Sincerely,
Betsy
E-iceblue support team