spread 使用ClusteredBarSeries问题

收藏

未命名.JPG (28.28 KB, 下载次数: 677)

2013-1-30 10:29 上传

点击文件名下载附件
如上图，我现在想达到的效果是：红色柱形和蓝色柱形分别表示两个东西，红色柱形对应右侧的yAxis，而蓝色对应左侧的yAxis
现在做出的效果是蓝色对应上了，但是红色图形的图像表示有问题（例如“心脏”列表示,明显和右侧的y轴对应不上），下面是我实现的代码

fpSpread_Bar.Sheets[0].Charts.Clear();
BarSeries bseries_People = new BarSeries();
bseries_People.GapWidth = 0.25F;
bseries_People.YAxisId = 1;
bseries_People.BarFill = new SolidFill(Color.Red);
bseries_People.SeriesName = "预约人数";
bseries_People.LabelVisible = true;
BarSeries bseries_Cost = new BarSeries();
bseries_Cost.GapWidth = 0.25F;
bseries_Cost.BarFill = new SolidFill(Color.Blue);
bseries_Cost.SeriesName = "检查费用";
bseries_Cost.LabelVisible = true;
ClusteredBarSeries CBseries = new ClusteredBarSeries();
int iCount = 0;
for (int i = 0; i < fpSpread_Table.Sheets[0].RowCount - 2; i++)
{
if (fpSpread_Table.Sheets[0].Cells[i, 1].Text != "")
{
bseries_People.Values.Add(Convert.ToDouble(fpSpread_Table.Sheets[0].Cells[i, 1].Text));
bseries_Cost.Values.Add(Convert.ToDouble(fpSpread_Table.Sheets[0].Cells[i, 2].Text));
if (fpSpread_Table.Sheets[0].Cells[i, 0].Text != "")
{
bseries_People.CategoryNames.Add(fpSpread_Table.Sheets[0].Cells[i, 0].Text);
bseries_Cost.CategoryNames.Add(fpSpread_Table.Sheets[0].Cells[i, 0].Text);
}
iCount++;
}
}
ValueAxis y2 = new ValueAxis();
y2.AxisId = 1;
y2.Maximum = 8;
y2.Minimum = 0;
y2.LabelVisible = true;
y2.Location = AxisLocation.Far;
y2.DisplayUnits = 0.1;
CBseries.LabelVisible = true;
CBseries.Series.Add(bseries_People);
CBseries.Series.Add(bseries_Cost);
YPlotArea plotArea = new YPlotArea();
plotArea.Location = new PointF(0.2f, 0.2f);
plotArea.Size = new SizeF(0.6f, 0.6f);
plotArea.Series.Add(CBseries);
plotArea.YAxes.Add(y2);
plotArea.YAxes[0].Title = "检查费用";
plotArea.YAxes[0].TitleOffset = 18;
plotArea.YAxes[1].Title = "预约人数";
plotArea.YAxes[1].TitleOffset = 18;
//添加标题
LabelArea label = new LabelArea();
label.Location = new PointF(0.5f, 0.02f);
label.AlignmentX = 0.5f;
label.AlignmentY = 0.0f;
label.Text = "组合图表";
LegendArea legend = new LegendArea();
legend.Location = new PointF(0.98f, 0.2f);
legend.AlignmentX = 1.0f;
legend.AlignmentY = 0.5f;
ChartModel model = new ChartModel();
model.PlotAreas.Add(plotArea);
model.LabelAreas.Add(label);
model.LegendAreas.Add(legend);
//fpSpread_Bar.ActiveSheet.AddChart(0, 0, typeof(BarSeries), 800, 400, 0, 0);
fpSpread_Bar.ActiveSheet.AddChart(0, 0, typeof(BarSeries), iCount * 110, iCount * 55, 0, 0);
fpSpread_Bar.ActiveSheet.Charts[0].Model = model;
fpSpread_Bar.ActiveSheet.Charts[0].Locked = true;