Legend Chart and Value Shown As Label

Thread is closed for posting
2 posts, 0 answers
  1. Chevy Mark
    Chevy Mark avatar
    1 posts
    Member since:
    Mar 2012

    Posted 07 Mar 2012 Link to this post

    <%@ Import Namespace="System.Data.Odbc" %>
    <%@ Import Namespace="System.Drawing" %>
    <%@ Import Namespace="System.IO" %>
    <%@ Import Namespace="System.Collections.Generic" %>
    <%@ Import Namespace="System.Linq" %>
    <%@ Import Namespace="System.Configuration" %>
    <%@ Import Namespace="System.Security.Principal" %>
    <%@ Import Namespace="System.Text" %>
    <%@ Import Namespace="DocumentFormat.OpenXml" %>
    <%@ Import Namespace="DocumentFormat.OpenXml.Presentation" %>
    <%@ Import Namespace="DocumentFormat.OpenXml.Packaging" %>
    <%@ Import Namespace="DocumentFormat.OpenXml.Drawing" %>
     
     
    <%@ Register Assembly="System.Web.DataVisualization, Version=4.0.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35"
        Namespace="System.Web.UI.DataVisualization.Charting" TagPrefix="asp" %>
     
    <head id="Head1" runat="server">
    <title>Chart</title>
    <script runat="server">  
     
     
       private void Page_Load(object sender, System.EventArgs e)
       {
            
           OdbcConnection myConnectionString = new OdbcConnection(ConfigurationManager.ConnectionStrings["ConnMySQL"].ConnectionString);
           myConnectionString.Open();
     
           String strQuery = " SELECT AAA, BBB, CCC, DDD, EEE, myDates from myTbl; ";
     
           OdbcCommand objCmd = new OdbcCommand(strQuery, myConnectionString);
           objCmd.CommandType = CommandType.Text;
           objCmd.CommandText = strQuery;
     
          
           Chart1.DataSource = objCmd.ExecuteReader();      
            
           Chart1.ChartAreas["ChartArea1"].Area3DStyle.Inclination = 0;
           Chart1.ChartAreas["ChartArea1"].Area3DStyle.Enable3D = false;
           Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.Angle = -35;
           Chart1.ChartAreas["ChartArea1"].AxisX.IsLabelAutoFit = false;
           Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.Font = new System.Drawing.Font("Arial", 8);
           Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.IsStaggered = false;
           Chart1.ChartAreas["ChartArea1"].AxisX.LabelStyle.Enabled = true;
           Chart1.ChartAreas["ChartArea1"].AxisX.IsMarginVisible = true;
           Chart1.ChartAreas["ChartArea1"].AxisX.LineColor = Color.Black;
           Chart1.ChartAreas["ChartArea1"].AxisY.LineColor = Color.Black;
           Chart1.ChartAreas["ChartArea1"].AxisX.LineDashStyle = ChartDashStyle.Solid;
           Chart1.ChartAreas["ChartArea1"].AxisX.LineWidth = 3;
           Chart1.ChartAreas["ChartArea1"].AxisY.LineWidth = 3;
           Chart1.AntiAliasing = AntiAliasingStyles.All;
           Chart1.TextAntiAliasingQuality = TextAntiAliasingQuality.High;
     
     
           Chart1.Series["Default"].XValueMember = "AAA";
           Chart1.Series["Default"].YValueMembers = "BBB";
           Chart1.Series["Default"].ChartType = SeriesChartType.Column;
           Chart1.Series["Default"]["PointWidth"] = "0.7";
           Chart1.Series["Default"].IsValueShownAsLabel = true;
           Chart1.Series["Default"]["BarLabelStyle"] = "Center";
           Chart1.Series["Default"]["PixelPointDepth"] = "99";
           Chart1.Series["Default"]["DrawingStyle"] = "Cylinder";
           Chart1.Series["Default"].Font = new System.Drawing.Font("Verdana", 10);
           Chart1.Series["Default"]["LabelStyle"] = "Top";
     
           Chart1.Series["Default2"].YValueMembers = "CCC";
           Chart1.Series["Default2"].ChartType = SeriesChartType.Column;
           Chart1.Series["Default2"]["LabelStyle"] = "Center";
           Chart1.Series["Default2"]["PointWidth"] = "0.7";
           Chart1.Series["Default2"].IsValueShownAsLabel = true;
           Chart1.Series["Default2"].Font = new System.Drawing.Font("Verdana", 10);
           Chart1.Series["Default2"]["LabelStyle"] = "TopLeft";
           Chart1.Series["Default2"]["BarLabelStyle"] = "Center";
           Chart1.Series["Default2"]["PixelPointDepth"] = "99";
           Chart1.Series["Default2"]["DrawingStyle"] = "Cylinder";
     
            
           Chart1.Series["Default3"].YValueMembers = "DDD";
           Chart1.Series["Default3"].ChartType = SeriesChartType.Line;
           Chart1.Series["Default3"].Font = new System.Drawing.Font("Verdana", 12);
           Chart1.Series["Default3"]["LabelStyle"] = "TopLeft";
     
           Chart1.Series["Default4"].YValueMembers = "EEE";
           Chart1.Series["Default4"].ChartType = SeriesChartType.Column;
           Chart1.Series["Default4"]["PointWidth"] = "0.7";
           Chart1.Series["Default4"].IsValueShownAsLabel = true;
           Chart1.Series["Default4"]["BarLabelStyle"] = "Center";
           Chart1.Series["Default4"]["PixelPointDepth"] = "99";
           Chart1.Series["Default4"]["DrawingStyle"] = "Cylinder";
           Chart1.Series["Default4"].Font = new System.Drawing.Font("Verdana", 10);
           Chart1.Series["Default4"]["LabelStyle"] = "Top";
     
           Chart1.Legends.Add(new Legend("Default"));
           Chart1.Series["Default"].Legend = "Default";
           Chart1.Legends["Default"].BackColor = Color.MediumSeaGreen;
           Chart1.Legends["Default"].BackSecondaryColor = Color.Green;
           Chart1.Legends["Default"].BackGradientStyle = GradientStyle.DiagonalLeft;
           Chart1.Legends["Default"].BorderColor = Color.Black;
           Chart1.Legends["Default"].BorderWidth = 2;
           Chart1.Legends["Default"].BorderDashStyle = ChartDashStyle.Solid;
           Chart1.Legends["Default"].ShadowOffset = 2; 
            
           myConnectionString.Close();
           myConnectionString.Dispose();
     
       }  
    </script>
     
    </head>
    <body>
        <form id="form1" runat="server">
        <div>
     
    <asp:Chart ID="Chart1" runat="server" Width="1058" Height="680">
    <Series>
    <asp:Series Name="Default" ChartArea="ChartArea1" Color="MediumOrchid" BorderWidth="2">
    </asp:Series>
    </Series>
     
    <Series>
    <asp:Series Name="Default2" ChartArea="ChartArea1" Color="Maroon" BorderWidth="2">
    </asp:Series>
    </Series>
     
    <Series>
    <asp:Series Name="Default3" ChartArea="ChartArea1" Color="Red" BorderWidth="4">
    </asp:Series>
    </Series>
     
    <Series>
    <asp:Series Name="Default4" ChartArea="ChartArea1" Color="Blue" BorderWidth="2">
    </asp:Series>
    </Series>
     
    <ChartAreas>
    <asp:ChartArea Name="ChartArea1">
    <AxisX Interval="1">
    </AxisX>
    </asp:ChartArea>
    </ChartAreas>
    </asp:Chart>
     
        </div>
        </form>
    </body>
    </html>   


    Hi there, I hope your help.

    I need in the legend chart:
    1) add the date of update of recordset from select query ( field  `myDates` );
    2) add the current month previous year;
    3) add the current month current year;

    I need resolve this problems in chart:
    4) the Value Shown As Label in the series "Default4" remains hidden from the series "Default3" (e.g. value 2.96);
    5) I change the font color in the "Default2" (e.g. value 14.73).

    how can I do that?
    thanks
  2. Peshito
    Admin
    Peshito avatar
    496 posts

    Posted 12 Mar 2012 Link to this post

    Hello,

    From your code provided I can see that you are not using Telerik's RadChart. You can find our more about the features and capabilities of RadChart in our help topics and online demo examples here:
    http://www.telerik.com/help/aspnet-ajax/radchart-chartoverview.html
    http://www.telerik.com/help/aspnet-ajax/radchart-getting-started-create-data-bound.html
    http://www.telerik.com/help/aspnet-ajax/radchart-building.html
    http://demos.telerik.com/aspnet-ajax/chart/examples/overview/defaultcs.aspx
    http://demos.telerik.com/aspnet-ajax/chart/examples/databinding/database/defaultcs.aspx

    All the best,
    Peshito
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top