asp.net - ASP Chart Control - issue displaying all SQL data -


i new @ using mschart control. know how single series of data display in column chart, having issues displaying multiple data values in chart. here data sql query need display:

area      totalcnt   compliant  cpercent     noncompliant   ncpercent area1      29027      25468      87.7            3559        12.3 area2      13659      12035      88.1            1624        11.9 area3      25358      22221      87.6            3137        12.4 area4      47747      42340      88.7            5407        11.3 

here's series section of column chart:

<series> <asp:series isvalueshownaslabel="true" chartarea="chartarea1" label="#valy" name="compliant" bordercolor="180, 26, 59, 105" color="#00cc00" xvaluemember="area" yvaluemembers="compliant"></asp:series> <asp:series isvalueshownaslabel="true" chartarea="chartarea1" label="#valy" name="non-compliant" bordercolor="180, 26, 59, 105" color="255, 0, 0" xvaluemember="area" yvaluemembers="noncompliant"></asp:series> </series> 

any appreciated. added entire chart control below:

<asp:chart id="chart1" runat="server" datasourceid="sqldatasource1" width="800px" height="400px" palette="brightpastel" bordercolor="181, 64, 1" borderlinedashstyle="solid" backgradientstyle="topbottom" borderwidth="2" backcolor="#f3dfc1" imagetype="png" imagelocation="~\tempimages\chartpic_#seq(300,3)">    <titles>    <asp:title shadowcolor="32, 0, 0, 0" font="trebuchet ms, 14.25pt, style=bold" shadowoffset="3" text="datasource data binding" alignment="topleft" forecolor="26, 59, 105"></asp:title>    </titles>     <legends>         <asp:legend name="legend1" enabled="true" istextautofit="true" backcolor="transparent" font="trebuchet ms, 8.25pt, style=bold">         </asp:legend>         <asp:legend headerseparator="line" name="legend2">                 <cellcolumns>                     <asp:legendcellcolumn columntype="seriessymbol" headertext="region" name="column1">                         <margins left="15" right="15" />                     </asp:legendcellcolumn>                 </cellcolumns>             </asp:legend>      </legends>     <borderskin skinstyle="emboss"></borderskin>         <series>             <asp:series isvalueshownaslabel="true" legend="legend1" chartarea="chartarea1" label="#valy" name="compliant" bordercolor="180, 26, 59, 105" color="#00cc00" xvaluemember="area" yvaluemembers="compliant">             </asp:series>     <asp:series isvalueshownaslabel="true" legend="legend1" chartarea="chartarea1" label="#valy" name="non-compliant" bordercolor="180, 26, 59, 105" color="255, 0, 0" xvaluemember="area" yvaluemembers="noncompliant">              </asp:series>         </series>     <chartareas>         <asp:chartarea name="chartarea1" bordercolor="64, 64, 64, 64" borderdashstyle="solid" backsecondarycolor="white" backcolor="oldlace" shadowcolor="transparent" backgradientstyle="topbottom">         <area3dstyle rotation="10" perspective="10" inclination="15" isrightangleaxes="false" wallwidth="0" isclustered="false"></area3dstyle>                       <axisx linecolor="64, 64, 64, 64" islabelautofit="false">         <labelstyle font="trebuchet ms, 8.25pt, style=bold" />         <labelstyle enabled="true" />         <majorgrid linewidth="1" />         <majortickmark enabled="false" />         </axisx>         <axisy linecolor="64, 64, 64, 64" islabelautofit="false">         <labelstyle font="trebuchet ms, 8.25pt, style=bold" />         <majorgrid linecolor="64, 64, 64, 64" />         <labelstyle enabled="true" />         <majorgrid linewidth="1" />         <majortickmark enabled="false" />         </axisy>     </asp:chartarea>   </chartareas> </asp:chart> 


Comments

Popular posts from this blog

javascript - AngularJS custom datepicker directive -

javascript - jQuery date picker - Disable dates after the selection from the first date picker -