最近一段时间要用MSChart写几个报表,所以刚开始接触,写了几个报表之后对MSchart有了一点总结
1.属性
1.1 Series
Char1.Legends["Legend" + i].LegendStyle = LegendStyle.Column;//按列显示
Char1.Legends["Legend" + i].Docking = Docking.Right;//显示在右上角;
Char1.Series[seriesName].BorderWidth = 3;
//节点大小为5
Char1.Series[seriesName].MarkerSize = 7;
Char1.Series[seriesName].IsVisibleInLegend = false;
1.2 ChartAreas
- Chart1.ChartAreas[0].AxisX.Interval = 1; //设置X轴坐标的间隔为1
- Chart1.ChartAreas[0].AxisX.IntervalOffset = 1; //设置X轴坐标偏移为1
- Chart1.ChartAreas[0].AxisX.LabelStyle.IsStaggered = true; //设置是否交错显示,比如数据多的时候分成两行来显示
- //在y轴上有交点
- Char1.ChartAreas["ChartAreasValue"].AxisX.IsMarginVisible = false;
- Char1.Titles.Add(string.Format("{0}年勘测设计产值完成情况", this.ddlSearchYear.SelectedValue));
- Char1.ChartAreas["ChartAreasValue"].AxisY.Title = "单位:万元";
1.3 图表
- ChartDataTableHelper TableHelper = new ChartDataTableHelper();
- //显示合计
- TableHelper.Initialize(Char1,false);
2.绑定
2.1
- //一个柱子
- DataRow[] dtChartData = DsResult.Tables["DtDeptResult"].Select("1=1");
- string xValueMember = "DeptName";
- string yValueMembers = "AllMark";
- chartDeptMark.DataSource = dtChart.DefaultView;
- chartDeptMark.Series.Add("Series1");
- chartDeptMark.Series["Series1"].XValueMember = xValueMember;
- chartDeptMark.Series["Series1"].YValueMembers = yValueMembers;
- //一条数据中的多列对应多个Y值
- DataRow[] drResult = GetValueOfYear().Select("StatYear=100");
- for (int i = 0; i < 12; i++)
- {
- if (startMonth > 12)
- {
- startMonth -= 12;
- }
- montharr[i] = startMonth;
- string columnName = "CVM" + startMonth;
- Char1.Series["Series0"].Points.AddXY(startMonth.ToString(), drResult[0][columnName]);
- //Char1.Series["Series0"].XValueMember = montharr;
- startMonth++;
- }
- //多行数据
- for (int i = 0; i < dtResult.Columns.Count; i++)
- {
- string columnName = dtResult.Columns[i].ColumnName;
- string seriesName = "Series" + i;
- Char1.Series.Add(seriesName);
- Char1.Series[seriesName].Points.DataBindXY (dtResult.DefaultView, "BelongType", dtResult.DefaultView, columnName);
- }
2.2 分裂饼图
- DataTable dtResult = GetResult();
- Char1.Series.Add("serie0");
- Char1.Series["serie0"].Points.DataBind(dtResult.DefaultView, "BelongType", "BelongTypeRatio", "LegendText=" + "BelongType");
- Char1.Series["serie0"].ChartType = (SeriesChartType)Enum.Parse(typeof(SeriesChartType), "Pie", true);
- Char1.Legends.Add("Legend0");
- Char1.Series["serie0"].Label = "#LEGENDTEXT:#PERCENT{P}";
- Char1.Series["serie0"]["PieLabelStyle"] = "Outside";
- 对否将值作为标签来显示
- Char1.Series["serie0"].IsValueShownAsLabel = true;
- //分裂图
- foreach (DataPoint point in Char1.Series["serie0"].Points)
- {
- point["Exploded"] = "true";
- }
3.事件
- //对图中的图形添加单击事件,该例子是单击柱子后调用前台函数,跳转详细页面
- chartDeptMark.Series["Series1"].MapAreaAttributes = "οnclick=\"javascript:return DeptMark('#VALX');\"";