AreaChart 以线条下方的填充区域显示数据,适用于展示趋势的幅度和比较各系列的贡献。

示例

准备数据

var sheet = grid.CurrentWorksheet;

sheet["A2"] = new object[,] {
    { null, 2008, 2009, 2010, 2011, 2012 },
    { "City 1", 3, 2, 4, 2, 6 },
    { "City 2", 7, 5, 3, 6, 4 },
    { "City 3", 13, 10, 9, 10, 9 },
    { "Total", "=SUM(B3:B5)", "=SUM(C3:C5)", "=SUM(D3:D5)",
      "=SUM(E3:E5)", "=SUM(F3:F5)" },
};

233

定义范围并创建图表

var dataRange = sheet.Ranges["B3:F5"];
var serialNamesRange = sheet.Ranges["A3:A5"];
var categoryNamesRange = sheet.Ranges["B2:F2"];

sheet.AddHighlightRange(categoryNamesRange);
sheet.AddHighlightRange(serialNamesRange);
sheet.AddHighlightRange(dataRange);

var chart = new Chart.AreaChart
{
    Bounds = new Graphics.Rectangle(30, 150, 400, 240),
    Title = "Area Chart Sample",
    DataSource = new WorksheetChartDataSource(sheet, serialNamesRange, dataRange)
    {
        CategoryNameRange = categoryNamesRange,
    },
};

sheet.FloatingObjects.Add(chart);

339

半透明区域

由于较大的区域可能覆盖较小的区域,您可以将所有系列设置为半透明:

foreach (var style in chart.DataSerialStyles)
{
    style.FillColor = new Graphics.SolidColor(100, style.FillColor.ToSolidColor());
}

340

相关主题

这篇文章对您有帮助吗?