Telerik Forums / UI for ASP.NET AJAX
This is a migrated thread and some comments may be shown as answers.

Legend Chart and Value Shown As Label

1 Answer 211 Views
Chart (Obsolete)
This is a migrated thread and some comments may be shown as answers.
Chevy Mark
Top achievements
Rank 1
Chevy Mark asked on 07 Mar 2012, 06:27 PM
76322.png
<%@ 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

1 Answer, 1 is accepted

Sort by
0
Peshito
Telerik team
answered on 12 Mar 2012, 10:35 AM
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.
Tags
Chart (Obsolete)
Asked by
Chevy Mark
Top achievements
Rank 1
Answers by
Peshito
Telerik team
Share this question
or