I have data in data table like below.
I am trying to make graph like below using asp.net chart control (made graph in excel with some test data)
points are X and Y values. lines are linear, exponential, logarithmic and power values.
how can I make this chart in asp.net (vb.net or c#)? I am newbie to chart control.
This is my aspx code :
<asp:Chart ID="ChartAlertes" runat="server" Width="500px">
<Titles>
<asp:Title Text="Nombre d'alertes et leurs status en fonction des filtres renseignés"
BorderColor="Black" Alignment="TopCenter">
</asp:Title>
</Titles>
[code]...
I display 2 Points (2 columns) in the Chart Control and I change the color of the each Points with :
ChartAlertes.Series[0].Points[0].Color = System. Drawing. Color.Red;ChartAlertes.Series[0].Points[1].Color = System.Drawing.Color.DarkOrange;
But sometimes, I have only 1 Point to display or nothing at all on the Chart. So I'd like to check If there are some Points before to put the color of each Point.
For example :
if (ChartAlertes.Series[0].Empty == false)
{
//...
}
I have line chart which has values :
[code]...
when we set IsValueShownAsLabel=true on y-axis it shows value 0.
but graph showing values below zero at last 0.00 before 327.78.
Because I m new user cannot upoad image have a look Chart image from below url: [URL]
how to work with multiple series! for example: with 2 series and display the name of each series in the graph! like this example: URL...
View 1 RepliesOn my X Axis, I have months. The chart shows up to 11 points, i.e. Jan - Nov of the same year, but when I add 12 points (Jan - Dec), it will do an auto label thing and change the interval for every 4 months.
How can I change the graph so that it shows 12 months before it does the auto labels?
Here is the server control code I am currently using.
[code]....
I work with a tank of visual studio when I click to display the graph he shows not all points on the X axis
for example the table nbr_num_semaine_av contains values in order
(18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,1,2,3,4)
but the graph shows on the X axis only that 18, 38, 41
for (int k = 0; k < semaine.Count(); k++) {
Chart4.Series["Nombre de points terminés"].Points.AddXY(nbr_num_semaine_av[k], nbr_points_Termin[k]);
Chart4.Series["Nombre Total d'element"].Points.AddXY(nbr_num_semaine_av[k], nbr_element.Count());
}
Chart4.Series["Nombre de points terminés"].ChartType = SeriesChartType.Line;
Chart4.Series["Nombre Total d'element"].ChartType = SeriesChartType.Line;
Chart4.Series["Nombre de points terminés"].IsXValueIndexed = true;
Chart4.Visible = true;
I am currently making a line chart of Ajax control toolkit referring to an article [URL] .....
It works fines as described. My question is how to reverse Y axis of the line chart.
I need to place 1 (not 0) at the top of Y axis and biggest number near the bottom with some margin from axis X. The described chart is biggest number neat the top and 0 at the bottom.
I work with a charline (ajax control toolkit) and I want to manipulate from code behind but I do not really know how! I have an example but the data are in the aspx code.
<ajaxToolkit:LineChart ID="LineChart1" runat="server"
ChartWidth="450" ChartHeight="300" ChartType="Basic"
ChartTitle="United States versus European Widget Production"
CategoriesAxis="2007,2008,2009,2010,2011,2012"
ChartTitleColor="#0E426C" CategoryAxisLineColor="#D08AD9"
[code]....
Is it possible to display bullet points with 2 on the same line?
View 6 RepliesIn the control Chart, I add few points, selected from the database:
var Diagram_1 = Razrez_D1.Series ["D1"];
sqlDA.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlDA.SelectCommand.CommandText = "Razrez_D1";
sqlDA.SelectCommand.Parameters ["@ date1"]. Value = Session ["date1"]. ToString ();
sqlDA.SelectCommand.Parameters ["@ date2"]. Value = Session ["date2"]. ToString ();
sqlDA.Fill (dataSet1, "Razrez_D1");
sqlDA.SelectCommand.CommandType = CommandType.Text;
for (int i = 0; i <dataSet1.Razrez_D1.Rows.Count; i + +)
(
string name_s = dataSet1.Razrez_D1 [i]. Name.ToString ();
name_s = name_s.Substring (name_s.IndexOf ('№')). Trim ();
Diagram_1.Points.AddXY (name_s, dataSet1.Razrez_D1 [i]. Count);
Diagram_1.Points [i]. BorderColor = System.Drawing.Color.Black;;
Diagram_1.Points [i]. BorderWidth = 1;
if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count)> 5)
(
Diagram_1.Points [i]. Color = System.Drawing.Color.Red;
)
else if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count)> = 4 & & Convert.ToInt32
(dataSet1.Razrez_D1 [i]. count) <= 5)
(
Diagram_1.Points [i]. Color = System.Drawing.Color.Yellow;
)
else if (Convert.ToInt32 (dataSet1.Razrez_D1 [i]. count) <4)
(
Diagram_1.Points [i]. Color = System.Drawing.Color.Green;
)
)
The problem is that the points on the X axis are signed that way: first is not signed, second is signed, third is not signed etc How can I sigh all points?
I'm working within the confines of ASP.NET and HTML.
I have a gridview on the left and a gridview on the right.
When the user selects a checkbox in the left gridview and a checkbox in the right gridview, I would like a line to be rendered that connects the checkboxes.
Is there an efficient way to do this? Anything approaching this?
DrawLine(LeftCheckBox.Location, RightCheckbox.Location, Red, 1px)
The only thing I can think of that would be work, but be a poor solution, is positioning and stretching an Image vertically based upon where the selected checkboxes are.
so I have 3 series that are created from Cross Table Data Bind. Unfortunately some of the points are missing. Is there an algorithm I can use to cycle through the datapoints for each series and insert empty points to the correct spots so that my data is displayed correctly?
View 2 RepliesI have an ASP Chart (v4) which displays the data I need perfectly. I want it to show labels at the top of the data points and I am having some difficulty with it.
Here is my code that works for both series but does not display the labels:
[code]....
i have multiline textbox (word wrap property is true). if user type enter(for new line) or put space i can save into database as exactly as it is.(i 'm talking about text format) the problem is if user type not any "enter"(for new line) still textbox word wrap property works fine but when i save into database and read it, it is endless line(there isn't any line break)... i need to put new line character at word wrap points. is there any easy slutions?
http://www.youtube.com/watch?v=r-tAfdzPVzQ
I am currently using the new asp.net chart control.In this control i am not setting the maximum, minimum and the interval value because they are dynamic.ow once the graph is populated from database, the asp.net is only generating 4-5 points on the y -axis, i want it to show at least 10 values.But i am not sure how to increase the number of points on Y & X Axis.
View 1 RepliesI have a graph created with MS Chart like the following picture. As you can see the vertical lines are messed up with value of the top of each bar. Here's the mark-up for the graph:
<asp:Chart ID="chtNBAChampionships" runat="server">
<Series>
<asp:Series Name="Championships" YValueType="Int32" ChartType="Column" ChartArea="MainChartArea" IsValueShownAsLabel="true">
<Points>
<asp:DataPoint AxisLabel="Celtics" YValues="17" />
<asp:DataPoint AxisLabel="Lakers" YValues="15" />
<asp:DataPoint AxisLabel="Bulls" YValues="6" />
<asp:DataPoint AxisLabel="Spurs" YValues="4" />
<asp:DataPoint AxisLabel="76ers" YValues="3" />
<asp:DataPoint AxisLabel="Pistons" YValues="3" />
<asp:DataPoint AxisLabel="Warriors" YValues="3" />
</Points>
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="MainChartArea">
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
I don't want the display the vertical line because it's messed up with the value on top of the each bar. How can I disable the vertical line?
My web service needs to do generate some line charts which will then be added to a PDF report that is streamed to the client.
How do I generate the line chart in the web service?
C#:
protected void Page_Load(object sender, EventArgs e) {
if (!IsPostBack) {
LineGraphFunction();
}
}
//code for line graph
protected void LineGraphFunction()
[code]....
HTML:
<cc1:LineChart ID="LineChart1" Width="500px" runat="server" ChartHeight="300" ChartWidth = "450" TooltipBorderColor="#D8D8D8" TooltipFontColor="blue"
ChartType="Basic" ChartTitleColor="#0E426C" Visible = "false" BorderColor="Blue" BorderWidth="1px"
CategoryAxisLineColor="#D08AD9" ValueAxisLineColor="#D08AD9" BaseLineColor="#A156AB">
</cc1:LineChart>
Problem is:
In the "LineChart", everytime last "y-axis" point is going out of graph (i.e., somewhere in the footer of x-axis)
X-axis Y-axis
3.4 5.2
5.3 7
2 8.7
1) like in above table, all the point will plot except the last x-axis and y-axis points. Also, y-axis value = 8.7 goes away from graph and comes in the footer of x-axis line.
2) like if x-axis = 3, y-axis=6, then 6 goes out of the graph and comes in footer of x-axis line.
But this problem occurs only when Im using SELECT query for a "particular Id" i.e.,
SELECT x,y from Table1 where Id='Gaug9' and DeletionDate is null
If I will remove where Id=' ' then it will work fine. But I need to plot graph based on particular Id's.
I'm trying to add a vertical line to an area chart like the following...
<asp:Chart id="chtTriage" Width="545" BackColor="#f2f2f2" runat="server">
<Series>
<asp:Series Name="srs" ChartType="Area" Color="LightGray">
<Points>
<asp:DataPoint XValue="0" YValues="1000" />
<asp:DataPoint XValue="5" YValues="2500" />
<asp:DataPoint XValue="10" YValues="6000" />
<asp:DataPoint XValue="15" YValues="4000" />
<asp:DataPoint XValue="20" YValues="2500" />
<asp:DataPoint XValue="25" YValues="2000" />
<asp:DataPoint XValue="30" YValues="1500" />
<asp:DataPoint XValue="35" YValues="1200" />
<asp:DataPoint XValue="40" YValues="1000" />
<asp:DataPoint XValue="45" YValues="500" />
<asp:DataPoint XValue="50" YValues="0" />
</Points>
</asp:Series>
</Series>
<ChartAreas>
<asp:ChartArea Name="chaTriage" BackColor="#f2f2f2">
<AxisY Title="Number of Dogs" Interval="1000" IntervalType="Number" IsMarginVisible="false">
<LabelStyle Font="Aerial, 8.25pt" />
<MajorGrid Enabled="false" />
</AxisY>
<AxisX Title="Triage Points" Interval="10" IntervalType="Number" IsStartedFromZero="true" Minimum="0" IsMarginVisible="false">
<LabelStyle Font="Aerial, 8.25pt" />
<MajorGrid Enabled="false" />
</AxisX>
</asp:ChartArea>
</ChartAreas>
</asp:Chart>
It is easy to use SQLDataSource as data data source in Column chart (see code below). Is there any easy way to use SQLDATASource to fill line chart with minimum configuration? Most samples I found on the web do not use SQLDATASOURCE as data source .
[Code]....
i m using Asp.Net Chart control i m using Line Chart i need to give the color the area under the line(ike google DashBoard)
View 3 RepliesI want to create line chart that shows Daily and last Month result in it (line chart)
View 1 RepliesURL....i want to change color of each point in this chart control
View 1 RepliesI use a LineChart control in asp.net and C# but I have a problem because my linechart in my page is black..
This is a screenshot (i did Ctrl + A to show you there are data on this chart) ....
I followed the article found in below link. When i run the page, only one line gets generated according to the values retireved last. URL....
C#
string query = string.Format("SELECT CHAR(CDATE, ISO),CSCUNITPRICE FROM UNITZ.DAILYLOG where fundcode = 'BAL'");
DataTable dt = GetData(query);
string[] x = new string[dt.Rows.Count];
decimal[] y = new decimal[dt.Rows.Count];
for (int i = 0; i < dt.Rows.Count; i++)
[code].....