MS Chart 构造交叉图

  最近要做个统计两个系统点击率的小模块，想到了用图表更为直观。如图：

 

 

前台代码：

<asp:Chart ID="Chart1" RenderType=ImageTag ImageLocation="..//..//TempImages//ChartPic_#SEQ(300,3)" BackColor="#e8f4ff" Palette=BrightPastel runat="server" Width=600px > <Legends> <asp:Legend Enabled=true></asp:Legend> </Legends> <ChartAreas> <asp:ChartArea Name="ChartArea1" BackSecondaryColor=White BackColor="OldLace" ShadowColor=Transparent Area3DStyle-Enable3D=true> <Area3DStyle Rotation="10" Perspective="10" Inclination="10" IsRightAngleAxes=false WallWidth="0" IsClustered=false /> <axisx LineColor="64, 64, 64, 64" Interval=1 IsLabelAutoFit=true > <LabelStyle Font="Trebuchet MS, 8.25pt, style="Bold" mce_style="Bold"" /> <MajorGrid LineColor="64, 64, 64, 64" /> </axisx> </asp:ChartArea> </ChartAreas> </asp:Chart>

 

后台代码：

private void NowWeekDataBind(int intYear,int intWeek)//按周别查询 { SqlConnection con = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]); string strsql = "SELECT LOGINTYPE,LOGINWEEK,COUNT(*) as 次数 FROM UDS_LOGINCOUNT WHERE LOGINYEAR=" + intYear + " AND LOGINWEEK=" + intWeek + " GROUP BY LOGINTYPE,LOGINWEEK"; SqlCommand cmd = new SqlCommand(strsql, con); con.Open(); SqlDataReader dr = cmd.ExecuteReader(); Chart1.DataBindCrossTable(dr, "LOGINTYPE", "LOGINWEEK", "次数",""); Title t = new Title(intYear.ToString() + "年" + intWeek.ToString() + "周" + "OA&E-Flow登录次数统计图", Docking.Bottom, new System.Drawing.Font("Trbuchet MS", 14, System.Drawing.FontStyle.Bold), System.Drawing.Color.FromArgb(26, 59, 105)); Chart1.Titles.Add(t); dr.Close(); con.Close(); foreach (Series ser in Chart1.Series) { ser.IsValueShownAsLabel = true; } Chart1.DataBind(); }

 

注意1：Chart1.DataBindCrossTable(dr, "LOGINTYPE", "LOGINWEEK", "次数","");

此处为Chart1绑定交叉表，必须为该交叉表至少设置4个参数

注意2：

foreach (Series ser in Chart1.Series)
{
            ser.IsValueShownAsLabel = true;
}

此处为Chart1.Series逐一显示具体数值。