關於OWC兩個Y軸綁定數據的問題
来源:互联网 发布:年收入上千万 知乎 编辑:程序博客网 时间:2024/05/21 09:53
string xdata=string.Empty;
string ydata=string.Empty;
string zdata=string.Empty;
string zdata1=string.Empty;
string zdata2=string.Empty;
string xdata2=string.Empty;
xdata="374,296,240,100,300,200";
ydata="9,7,15,10,0,6";
zdata="0.0374,0.069,0.084,0.065,0,0.023";
zdata1="0.05,0.05,0.05,0.05,0.05,0.05";
OWC10.ChartSpaceClass myspace=new OWC10.ChartSpaceClass();
//myspace.Border.Color="Red" ; // 这样就看不到框线了..
//添加图表
//OWC10.ChChart mychart=myspace.Charts.Add(0);
OWC10.ChChart mychart=myspace.Charts.Add(0);
//指定图的类型
//mychart.Type=OWC10.ChartChartTypeEnum.chChartTypeColumnClustered;
mychart.Type=OWC10.ChartChartTypeEnum.chChartTypeColumnClustered; //是否有图例
mychart.HasLegend=true;
//是否有title
mychart.HasTitle=true;
mychart.Title.Caption="公司所有人员省别分析图";
mychart.Title.Font.Bold=true;
//为x轴加说明
// mychart.Axes[0].HasTitle=true;
// //mychart.Axes[0].Title.Caption="省别";
// mychart.Axes[0].Font.Color="Blue";
// mychart.Axes[0].HasTickLabels=true;
//为y轴加说明
//mychart.Axes[1].HasTitle=true;
//mychart.Axes[1].Title.Caption="人数";
mychart.Axes[1].Font.Color="Blue";
//mychart.Axes[1].MajorGridlines.Line.Color="Red"; //格线颜色
//mychart.Axes[1].MajorGridlines.Line.DashStyle=OWC10.ChartLineDashStyleEnum.chLineLongDash; //格线颜色
mychart.Axes[1].MajorGridlines.Line.DashStyle=OWC10.ChartLineDashStyleEnum.chLineLongDash; //格线颜色
mychart.Axes[1].MajorUnit=50;
//mychart.Axes[1].MajorTickMarks=OWC10.ChartTickMarkEnum.chTickMarkAutomatic;
mychart.Axes[1].MajorTickMarks=OWC10.ChartTickMarkEnum.chTickMarkAutomatic;
//把资料读入
string picname="项目";
string picname1="生产数";
string picname2="不良数";
string picname3="返修率";
string picname4="目标不良率";
mychart.SeriesCollection.Add(0);
mychart.SeriesCollection[0].DataLabelsCollection.Add();
mychart.SeriesCollection[0].DataLabelsCollection[0].HasValue=true;
mychart.SeriesCollection[0].DataLabelsCollection[0].Interior.Color="yellow"; //数值的背景色
mychart.SeriesCollection.Add(1);
mychart.SeriesCollection[1].Ungroup(true);
OWC10.ChAxis seAxes=mychart.Axes.Add(mychart.SeriesCollection[1].get_Scalings(OWC10.ChartDimensionsEnum.chDimValues));
seAxes.Position = OWC10.ChartAxisPositionEnum.chAxisPositionRight;
seAxes.HasMajorGridlines = false;
seAxes.NumberFormat = "0.00%";
seAxes.MajorUnit = 0.01;
seAxes.MajorTickMarks=OWC10.ChartTickMarkEnum.chTickMarkAutomatic;
mychart.SeriesCollection[1].DataLabelsCollection.Add();
mychart.SeriesCollection[1].DataLabelsCollection[0].HasValue=true;
mychart.SeriesCollection.Add(2);
mychart.SeriesCollection[2].DataLabelsCollection.Add();
//mychart.SeriesCollection[2].DataLabelsCollection[0].HasValue=true;
mychart.SeriesCollection[2].Type=OWC10.ChartChartTypeEnum.chChartTypeLine;
//mychart.SeriesCollection[3].DataLabelsCollection[0].HasPercentage=true;
mychart.SeriesCollection.Add(3);
mychart.SeriesCollection[3].DataLabelsCollection.Add();
mychart.SeriesCollection[3].Type=OWC10.ChartChartTypeEnum.chChartTypeLine;
//mychart.SeriesCollection[3].DataLabelsCollection[0].HasValue=false;
//mychart.SeriesCollection[3].DataLabelsCollection[0].HasPercentage=true;
//汇出为图档
mychart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname1); mychart.SeriesCollection[1].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname2);
mychart.SeriesCollection[2].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname4);
mychart.SeriesCollection[3].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname3);
//给定分类(生产数)
mychart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, ydata);
//(不良数)
mychart.SeriesCollection[1].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[1].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, zdata);
//返修率
mychart.SeriesCollection[3].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[3].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, zdata2);
//目标不良率
mychart.SeriesCollection[2].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[2].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, zdata1);
//汇出为图档
string mypath=(Server.MapPath(".")) + "//ShowData.gif";
myspace.ExportPicture(mypath,"GIF",890,240);
string ydata=string.Empty;
string zdata=string.Empty;
string zdata1=string.Empty;
string zdata2=string.Empty;
string xdata2=string.Empty;
xdata="374,296,240,100,300,200";
ydata="9,7,15,10,0,6";
zdata="0.0374,0.069,0.084,0.065,0,0.023";
zdata1="0.05,0.05,0.05,0.05,0.05,0.05";
OWC10.ChartSpaceClass myspace=new OWC10.ChartSpaceClass();
//myspace.Border.Color="Red" ; // 这样就看不到框线了..
//添加图表
//OWC10.ChChart mychart=myspace.Charts.Add(0);
OWC10.ChChart mychart=myspace.Charts.Add(0);
//指定图的类型
//mychart.Type=OWC10.ChartChartTypeEnum.chChartTypeColumnClustered;
mychart.Type=OWC10.ChartChartTypeEnum.chChartTypeColumnClustered; //是否有图例
mychart.HasLegend=true;
//是否有title
mychart.HasTitle=true;
mychart.Title.Caption="公司所有人员省别分析图";
mychart.Title.Font.Bold=true;
//为x轴加说明
// mychart.Axes[0].HasTitle=true;
// //mychart.Axes[0].Title.Caption="省别";
// mychart.Axes[0].Font.Color="Blue";
// mychart.Axes[0].HasTickLabels=true;
//为y轴加说明
//mychart.Axes[1].HasTitle=true;
//mychart.Axes[1].Title.Caption="人数";
mychart.Axes[1].Font.Color="Blue";
//mychart.Axes[1].MajorGridlines.Line.Color="Red"; //格线颜色
//mychart.Axes[1].MajorGridlines.Line.DashStyle=OWC10.ChartLineDashStyleEnum.chLineLongDash; //格线颜色
mychart.Axes[1].MajorGridlines.Line.DashStyle=OWC10.ChartLineDashStyleEnum.chLineLongDash; //格线颜色
mychart.Axes[1].MajorUnit=50;
//mychart.Axes[1].MajorTickMarks=OWC10.ChartTickMarkEnum.chTickMarkAutomatic;
mychart.Axes[1].MajorTickMarks=OWC10.ChartTickMarkEnum.chTickMarkAutomatic;
//把资料读入
string picname="项目";
string picname1="生产数";
string picname2="不良数";
string picname3="返修率";
string picname4="目标不良率";
mychart.SeriesCollection.Add(0);
mychart.SeriesCollection[0].DataLabelsCollection.Add();
mychart.SeriesCollection[0].DataLabelsCollection[0].HasValue=true;
mychart.SeriesCollection[0].DataLabelsCollection[0].Interior.Color="yellow"; //数值的背景色
mychart.SeriesCollection.Add(1);
mychart.SeriesCollection[1].Ungroup(true);
OWC10.ChAxis seAxes=mychart.Axes.Add(mychart.SeriesCollection[1].get_Scalings(OWC10.ChartDimensionsEnum.chDimValues));
seAxes.Position = OWC10.ChartAxisPositionEnum.chAxisPositionRight;
seAxes.HasMajorGridlines = false;
seAxes.NumberFormat = "0.00%";
seAxes.MajorUnit = 0.01;
seAxes.MajorTickMarks=OWC10.ChartTickMarkEnum.chTickMarkAutomatic;
mychart.SeriesCollection[1].DataLabelsCollection.Add();
mychart.SeriesCollection[1].DataLabelsCollection[0].HasValue=true;
mychart.SeriesCollection.Add(2);
mychart.SeriesCollection[2].DataLabelsCollection.Add();
//mychart.SeriesCollection[2].DataLabelsCollection[0].HasValue=true;
mychart.SeriesCollection[2].Type=OWC10.ChartChartTypeEnum.chChartTypeLine;
//mychart.SeriesCollection[3].DataLabelsCollection[0].HasPercentage=true;
mychart.SeriesCollection.Add(3);
mychart.SeriesCollection[3].DataLabelsCollection.Add();
mychart.SeriesCollection[3].Type=OWC10.ChartChartTypeEnum.chChartTypeLine;
//mychart.SeriesCollection[3].DataLabelsCollection[0].HasValue=false;
//mychart.SeriesCollection[3].DataLabelsCollection[0].HasPercentage=true;
//汇出为图档
mychart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname1); mychart.SeriesCollection[1].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname2);
mychart.SeriesCollection[2].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname4);
mychart.SeriesCollection[3].SetData(OWC10.ChartDimensionsEnum.chDimSeriesNames,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,picname3);
//给定分类(生产数)
mychart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[0].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, ydata);
//(不良数)
mychart.SeriesCollection[1].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[1].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, zdata);
//返修率
mychart.SeriesCollection[3].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[3].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, zdata2);
//目标不良率
mychart.SeriesCollection[2].SetData(OWC10.ChartDimensionsEnum.chDimCategories,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral,xdata);
mychart.SeriesCollection[2].SetData(OWC10.ChartDimensionsEnum.chDimValues,+(int)OWC10.ChartSpecialDataSourcesEnum.chDataLiteral, zdata1);
//汇出为图档
string mypath=(Server.MapPath(".")) + "//ShowData.gif";
myspace.ExportPicture(mypath,"GIF",890,240);
- 關於OWC兩個Y軸綁定數據的問題
- 漂亮的OWC图表
- OWC PivotTable的使用方法
- owc
- 利用OWC画图的例子
- OWC(Office Web Component)的使用
- OWC 的应用 - 柱状图(VB.NET)
- OWC中SpreadSheet控件的操作方法集合
- 利用 Office 的 OWC 做报表
- OWC做电子表格和图表的试验
- 利用OWC创建图表的完美解决方案
- OWC的Group()方法用于Series分组
- OWC 做电子表格和图表的试验
- OWC做电子表格和图表的试验
- OWC在展现时的翻译实现
- 使用owc开发报表的示例
- 关于对clientX(Y)/pageX(Y)/screenX(Y)的认识
- 新手喜闻乐见的x++,y++,++x,++y
- ERP流程
- 数组中最大和的子序列
- grails 中使用Fckeditor,读取数据库显示带有HTML标签问题
- 用InstallShield 进行ASP 软件的打包和自动安装
- 通过启用约束找出表中的重复记录
- 關於OWC兩個Y軸綁定數據的問題
- SAAS
- JAVA内存泄漏分析(五)
- GOGO
- 不想再做 '花瓶'
- 上班族的黑话集
- log4j:ERROR A''org.jboss.logging.unit.OnlyOnceErrorHandler"object is not assignable to a ''org.apache.log4j.spi.ErrorHandler'' v
- 通俗讲解什么是ipsec vpn
- 中小IT企业如何留住80后技术人才