如何设置波形图样式
问题描述:添加波形图后,Spread 会有默认的填充色,如何通过代码指定填充色。问题解答:波形图提供了FirstMarkerColor等相关属性用于定制填充颜色。
关键代码:
private void AddSparkLines()
{
FarPoint.Win.Spread.SheetView sv = new FarPoint.Win.Spread.SheetView();
FarPoint.Win.Spread.Chart.SheetCellRange data = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 0, 0, 1, 5);
FarPoint.Win.Spread.Chart.SheetCellRange data2 = new FarPoint.Win.Spread.Chart.SheetCellRange(sv, 5, 0, 1, 1);
FarPoint.Win.Spread.ExcelSparklineSetting ex = new FarPoint.Win.Spread.ExcelSparklineSetting();
ex.AxisColor = Color.SaddleBrown;
ex.ShowFirst = true;
ex.ShowHigh = true;
ex.ShowLow = true;
ex.ShowLast = true;
//自定义填充色
ex.FirstMarkerColor = Color.Blue;
ex.HighMarkerColor = Color.DarkGreen;
ex.MarkersColor = Color.Aquamarine;
ex.LowMarkerColor = Color.Red;
ex.LastMarkerColor = Color.Orange;
ex.ShowMarkers = true;
fpSpread1.Sheets = sv;
sv.Cells.Value = 2;
sv.Cells.Value = 5;
sv.Cells.Value = 4;
sv.Cells.Value = 1;
sv.Cells.Value = 3;
fpSpread1.Sheets.AddSparkline(data, data2, FarPoint.Win.Spread.SparklineType.Line, ex);
#endregion
}
?
效果截图:
示例下载:点击下载
页:
[1]