BarChart 以水平条形显示数据。它继承自 ColumnChart，坐标轴互换——默认隐藏水平辅助线并显示垂直辅助线。
示例
准备数据
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)" },
};定义范围并创建图表
var dataRange = sheet.Ranges["B3:F5"];
var serialNamesRange = sheet.Ranges["A3:A5"];
var categoryNamesRange = sheet.Ranges["B2:F2"];
sheet.AddHighlightRange(serialNamesRange);
sheet.AddHighlightRange(categoryNamesRange);
sheet.AddHighlightRange(dataRange);
var chart = new Chart.BarChart
{
Location = new Graphics.Point(460, 30),
Size = new Graphics.Size(400, 260),
Title = "Bar Chart Sample",
DataSource = new WorksheetChartDataSource(sheet, serialNamesRange, dataRange)
{
CategoryNameRange = categoryNamesRange,
},
};
sheet.FloatingObjects.Add(chart);
自定义
// 条形图默认值：水平辅助线关闭，垂直辅助线开启
chart.ShowHorizontalGuideLines; // false
chart.ShowVerticalGuideLines; // true
// 更改系列颜色
chart.DataSerialStyles[0].FillColor = Graphics.SolidColor.DarkOrange;