问题描述:添加波形图后,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[0] = sv;
- sv.Cells[0, 0].Value = 2;
- sv.Cells[0, 1].Value = 5;
- sv.Cells[0, 2].Value = 4;
- sv.Cells[0, 3].Value = 1;
- sv.Cells[0, 4].Value = 3;
- fpSpread1.Sheets[0].AddSparkline(data, data2, FarPoint.Win.Spread.SparklineType.Line, ex);
- #endregion
- }
复制代码
?
效果截图:
示例下载:点击下载 |