代码为
Microsoft.Office.Interop.Owc11.ChChart objChart = this.axChartSpace1.Charts.Add(0);
//将图形的类型设置为柱状图的一种
objChart.Type = Microsoft.Office.Interop.Owc11.ChartChartTypeEnum.chChartTypeColumnClustered; //将图形容器的边框颜色设置为白色
axChartSpace1.Border.Color = "White"; //显示主标题
objChart.HasTitle = true;
//设置标题内容、大小
objChart.Title.Caption = "实时业务量监控";
objChart.Title.Font.Bold = true;
objChart.Title.Font.Color = "Green";
objChart.Title.Font.Size = 24; //显示X轴标题
objChart.Axes[0].HasTitle = true;
objChart.Axes[0].Title.Caption = "任务类型";
objChart.Axes[0].Title.Font.Bold = true;
objChart.Axes[0].Title.Font.Size = 16;
objChart.Axes[0].Title.Font.Color = "Green";
objChart.Axes[0].HasMajorGridlines = true; //显示Y轴标题
//objChart.Axes[1].HasTitle = true;
//objChart.Axes[1].Title.Caption = "业务量";
//objChart.Axes[1].Title.Font.Bold = true;
objChart.Axes[1].Font.Size = 10;
//objChart.Axes[1].Title.Font.Color = "Green";
objChart.Axes[1].HasTickLabels = true;
//objChart.Axes[1].HasAutoMajorUnit=true;
//显示图例
objChart.HasLegend = true;
//设置图例字体大小
objChart.Legend.Font.Size = 10;
//设置图例位置为底端
objChart.Legend.Position = Microsoft.Office.Interop.Owc11.ChartLegendPositionEnum.chLegendPositionBottom; axChartSpace1.Visible = true; string Value = "";
string upvalue = "";
string setvalue = "";
string lowvalue = ""; Value = "0\t7\t9\t8\t10\t6\t3\t-1\t-2\t-5\t-9\t-10\t6\t-2\t5.4\t";
upvalue += "10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t";
setvalue += "0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t";
lowvalue += "-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t";
if (Value.Length >= 1)
{
Value = Value.Trim().Substring(0, Value.Length - 1);
}
if (upvalue.Length >= 1)
{
upvalue = upvalue.Trim().Substring(0, upvalue.Length - 1);
}
if (setvalue.Length >= 1)
{
setvalue = setvalue.Trim().Substring(0, setvalue.Length - 1);
}
if (lowvalue.Length >= 1)
{
lowvalue = lowvalue.Trim().Substring(0, lowvalue.Length - 1);
} objChart.SeriesCollection.Add(0);
objChart.SeriesCollection[0].SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimSeriesNames, (int)Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral, "等待录入");
objChart.SeriesCollection[0].SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimBubbleValues, (int)Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral, Value);就走到最后一句的时候报这个错,哪位高人指点下
Microsoft.Office.Interop.Owc11.ChChart objChart = this.axChartSpace1.Charts.Add(0);
//将图形的类型设置为柱状图的一种
objChart.Type = Microsoft.Office.Interop.Owc11.ChartChartTypeEnum.chChartTypeColumnClustered; //将图形容器的边框颜色设置为白色
axChartSpace1.Border.Color = "White"; //显示主标题
objChart.HasTitle = true;
//设置标题内容、大小
objChart.Title.Caption = "实时业务量监控";
objChart.Title.Font.Bold = true;
objChart.Title.Font.Color = "Green";
objChart.Title.Font.Size = 24; //显示X轴标题
objChart.Axes[0].HasTitle = true;
objChart.Axes[0].Title.Caption = "任务类型";
objChart.Axes[0].Title.Font.Bold = true;
objChart.Axes[0].Title.Font.Size = 16;
objChart.Axes[0].Title.Font.Color = "Green";
objChart.Axes[0].HasMajorGridlines = true; //显示Y轴标题
//objChart.Axes[1].HasTitle = true;
//objChart.Axes[1].Title.Caption = "业务量";
//objChart.Axes[1].Title.Font.Bold = true;
objChart.Axes[1].Font.Size = 10;
//objChart.Axes[1].Title.Font.Color = "Green";
objChart.Axes[1].HasTickLabels = true;
//objChart.Axes[1].HasAutoMajorUnit=true;
//显示图例
objChart.HasLegend = true;
//设置图例字体大小
objChart.Legend.Font.Size = 10;
//设置图例位置为底端
objChart.Legend.Position = Microsoft.Office.Interop.Owc11.ChartLegendPositionEnum.chLegendPositionBottom; axChartSpace1.Visible = true; string Value = "";
string upvalue = "";
string setvalue = "";
string lowvalue = ""; Value = "0\t7\t9\t8\t10\t6\t3\t-1\t-2\t-5\t-9\t-10\t6\t-2\t5.4\t";
upvalue += "10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t10\t";
setvalue += "0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t0\t";
lowvalue += "-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t-10\t";
if (Value.Length >= 1)
{
Value = Value.Trim().Substring(0, Value.Length - 1);
}
if (upvalue.Length >= 1)
{
upvalue = upvalue.Trim().Substring(0, upvalue.Length - 1);
}
if (setvalue.Length >= 1)
{
setvalue = setvalue.Trim().Substring(0, setvalue.Length - 1);
}
if (lowvalue.Length >= 1)
{
lowvalue = lowvalue.Trim().Substring(0, lowvalue.Length - 1);
} objChart.SeriesCollection.Add(0);
objChart.SeriesCollection[0].SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimSeriesNames, (int)Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral, "等待录入");
objChart.SeriesCollection[0].SetData(Microsoft.Office.Interop.Owc11.ChartDimensionsEnum.chDimBubbleValues, (int)Microsoft.Office.Interop.Owc11.ChartSpecialDataSourcesEnum.chDataLiteral, Value);就走到最后一句的时候报这个错,哪位高人指点下
修改图表类型与当前赋予数据要相匹配。建议你修改参数 //objChart.Type = ChartChartTypeEnum.chChartTypeColumnClustered3D; // 指定图表的类型为3D柱状
// objChart.Type = ChartChartTypeEnum.chChartTypeColumnClustered; // 平面柱状
objChart.Type = ChartChartTypeEnum.chChartTypeLine;
你的数据构造也类似你的,试试这个图表。