堆积柱形图 [英] stacked column chart
问题描述
请帮助我解决asp.net图表控件中的这个问题。
我需要将数据与数据库绑定,甚至可以根据y值动态添加系列。
下面的表有2列.date和value
要求是从数据库动态绑定数据。使用ado.net需要绑定数据集或数据表。
图表类型:堆积列
每个日期必须显示值(x值)
日期值
1   40
1 50
1 60
2 20
2 40
3 30
等等
这应该是这样的。
http://www.google.co.in/imgres?imgurl=http://support2.dundas.com/OnlineDocumentation/RSChart/ChartType_Images/StackedColumnChart.png&imgrefurl=http://support2 .dundas.com / OnlineDocumentation / RSChart / StackedColumnChart.html&安培; H = 326&安培; W = 404&安培; SZ = 64&安培; tbnid = uZ99WySJgD1hcM:安培; TBNH = 90&安培; tbnw = 112和缩放= 1&安培; USG = __ 71AYEuAVBUmpFm5E5xKHjUHViO4 =安培; docID的= 4vujBNbe4Kd2hM& hl = en& sa = X& ei = sKTcULjSL4HkrAfGv4CYDA& sqi = 2& ved = 0CDEQ9QEwAA& dur = 335
for 1(系列(y值)是< 40,50 ,60)for 2(20,40),for 3(30)
但是我没有得到每个 的确切值。 x值。
请将约束后的代码发布为
< Series>
< asp:Series Name =" Field1" XValueMember =" Ur X Value" YValueMembers =" Ur Y Value"颜色="深青绿"图图表= QUOT; StackedColumn">< / ASP:系列>
< asp:Series Name =" Field1" XValueMember =" Ur X Value" YValueMembers =" Ur Y Value"颜色="深青绿"图图表= QUOT; StackedColumn">< / ASP:系列>
< asp:Series Name =" Field1" XValueMember =" Ur X Value" YValueMembers =" Ur Y Value"颜色="深青绿"图图表= QUOT; StackedColumn">< / ASP:系列> &NBSP;
< / Series>
&NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < ChartAreas>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp:ChartArea Name =" ChartArea">< / asp:ChartArea> &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < / ChartAreas>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP;
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; <传奇>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < asp:Legend Name =" Legend"对接= QUOT;底座"对准= QUOT;中心" LegendItemOrder =" ReversedSeriesOrder">< / asp:Legend>
&NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; &NBSP; < /传说>&NBSP;
Please help me out for this issue in asp.net chart controls.
i need to bind the data with database and even dynamically add the series based on y values.
below table has the 2 columns.date and value
requirement is to bind the data dynamically from database.using ado.net need to bind with dataset or datatable.
chart type:stacked column
for each date the values must be dispalyed on(x values)
date value
1 40
1 50
1 60
2 20
2 40
3 30
and so on
It should be like in this way.http://www.google.co.in/imgres?imgurl=http://support2.dundas.com/OnlineDocumentation/RSChart/ChartType_Images/StackedColumnChart.png&imgrefurl=http://support2.dundas.com/OnlineDocumentation/RSChart/StackedColumnChart.html&h=326&w=404&sz=64&tbnid=uZ99WySJgD1hcM:&tbnh=90&tbnw=112&zoom=1&usg=__71AYEuAVBUmpFm5E5xKHjUHViO4=&docid=4vujBNbe4Kd2hM&hl=en&sa=X&ei=sKTcULjSL4HkrAfGv4CYDA&sqi=2&ved=0CDEQ9QEwAA&dur=335
for 1(series(y values) are 40,50,60) for 2(20,40), for 3(30)
But am not getting the exact values on every x values.
please post the code behind for binding<Series>
<asp:Series Name="Field1" XValueMember="Ur X Value" YValueMembers="Ur Y Value" Color="DarkCyan" ChartType="StackedColumn"></asp:Series>
<asp:Series Name="Field1" XValueMember="Ur X Value" YValueMembers="Ur Y Value" Color="DarkCyan" ChartType="StackedColumn"></asp:Series>
<asp:Series Name="Field1" XValueMember="Ur X Value" YValueMembers="Ur Y Value" Color="DarkCyan" ChartType="StackedColumn"></asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="ChartArea"></asp:ChartArea>
</ChartAreas>
<Legends>
<asp:Legend Name="Legend" Docking="Bottom" Alignment="Center" LegendItemOrder="ReversedSeriesOrder"></asp:Legend>
</Legends>
这篇关于堆积柱形图的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!