回复 1楼rongchao的帖子
可以通过 LabelFormatter 来转换为 日期等格式,可以通过 ChartDesigner 设计,方法请参考截图:
代码:
- FarPoint.Win.Spread.Model.GeneralFormatter test = new FarPoint.Win.Spread.Model.GeneralFormatter();
- test.SetFormatString("$#,##.00", false);
- FarPoint.Win.Spread.Model.GeneralFormatter test2 = new FarPoint.Win.Spread.Model.GeneralFormatter();
- test2.SetFormatString("#,##.00", false);
- FarPoint.Win.Chart.ValueAxis v1axis = new FarPoint.Win.Chart.ValueAxis();
- 1axis.LabelFormatter = test2;
- FarPoint.Win.Chart.BarSeries series = new FarPoint.Win.Chart.BarSeries();
- series.Values.Add(10.0);
- series.Values.Add(2.0);
- series.Values.Add(4.0);
- series.Values.Add(8.0);
- series.LabelVisible = true;
- series.LabelFormatter = test;
-
- FarPoint.Win.Chart.YPlotArea plotArea = new FarPoint.Win.Chart.YPlotArea();
- plotArea.Location = new PointF(0.2F, 0.2F);
- plotArea.Size = new SizeF(0.6F, 0.6F);
- plotArea.XAxis.LabelFormatter = test;
- plotArea.YAxes.Clear();
- plotArea.YAxes.Add(v1axis);
- plotArea.Series.Add(series);
- FarPoint.Win.Chart.ChartModel model = new FarPoint.Win.Chart.ChartModel();
- model.PlotAreas.Add(plotArea);
- FarPoint.Win.Spread.Chart.SpreadChart chart = new FarPoint.Win.Spread.Chart.SpreadChart();
- chart.Size = new Size(200, 200);
- chart.Location = new Point(100, 100);
- chart.Model = model;
- fpSpread1.Sheets[0].Charts.Add(chart);
复制代码 |