AJAX :: How To Set X-axis Min And Max Value From Database Table In MSChart Control
May 7, 2015
Suppose if DB table has x-axis values as below for particular Id: 65 67.5 68.5 70.0 78.5 80.0 81.5 82.5 83.0 83.5 84.0 84.5 85.5 86.5
Then it should select x-axis Min value as 65 (for that particular Id), in below line: //Chart1.ChartAreas["ChartArea1"].AxisX.Minimum and it should select x-axis Max value as 86.5 (for that particular Id, in below line: //Chart1.ChartAreas["ChartArea1"].AxisX.Maximum.These values differ everytime for different Id. ( particular Id has multiple x-So everytime for particular Id, it should take x-axis Min and Max value from Database.I tried below code, but its not working. (Also this code enables MajorGrid = true dont know how. I had set it Enable = false from code behind.)
string query = "SELECT max(x) from Tables where Param_ID= '" + id + "' and DeletionDate is null";
DataTable dt2 = GetData(query);
Chart1.ChartAreas["ChartArea1"].AxisX.Maximum = Convert.ToDouble(dt2);
View 1 Replies
Similar Messages:
Mar 29, 2010
I have installed the asp.net MSChart control for VS2008 and set up a chart on my webform. I am using DataBindTable in code to bind data from a LINQ query. The data for the x axis looks something like this:
Date/Time
15/03/2010 08:00:00
15/03/2010 14:00:00
15/03/2010 20:00:00
16/03/2010 08:00:00
16/03/2010 14:00:00
etc
When the chart displays the X axis only displays multiple dates, and not times, no matter what properties I try to change.
View 2 Replies
Oct 18, 2010
I have an mschart control which is databound in code-behind. The Y axis values can vary from vary small to very broad. So the range is set to auto. This works fine except when the values in range of 0 and <1.
In this range the axis only has a zero, it does not have a "1" at top. Is it possible to set to dynamically set the maximum? So if the maximum value is less than one, still show a one.
i.e. get maximum value and set the Y axis maximum = maximum value +1
View 5 Replies
Oct 28, 2013
I have an MsChart with 6 series. The data is retrieved from MySQL database and every series has different number of elements.
The X axis is represented by date values (YYYY-MM). I am sorting data ASC on date from MySQL query but when i generate the chart i have the values (from left to right) : 2010-01 , 2011-04, 2013-04, 2011-04,2012-04.
I tried sorting data like this , for every series:
Code:
Chart1.Series(0).Sort(PointSortOrder.Ascending, "X")
But still no effect. How can i sort data on X axis?
View 4 Replies
Mar 6, 2013
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;
View 1 Replies
Feb 1, 2014
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.
View 1 Replies
Mar 30, 2011
Iam having simple chart.
Which is displaying X and Y values.
Iam using SqlDataSource control to Bind data from database.
Now, How to display Sum of X values on top of chart ?
View 1 Replies
Sep 6, 2010
I want to display time on Y axis and days on x axis.
I want to dispaly 12:00 AM,11:00 AM...11:59 PM. on Y axis.I want function to create sequence like that and on X axis display week like 6-sep,7-sep,..11-sep.
View 6 Replies
Dec 23, 2010
How can I display a TimeSeries?Is it possible to use the MSChart Control (Asp.net Charting Control)?
View 3 Replies
Dec 15, 2010
I would like to install my asp .net site on a free host. what do I need to install in order that the mschart control will work on the host.
what are the basic requirements.
at the moment I get an error about it.
View 2 Replies
Jan 12, 2011
I am wondering if I am able to align y-labels at chart if I am using MSchart control. I searched at google, but I got feeling it is not possible to align them, just title of y-axis.
Here snip of the chart if my question is not clear enough: [URL]
View 2 Replies
Jan 31, 2011
I want to programmatically turn on/off the labels on an Chart Control.
The chart is for a load of stats, by person, and I want to be able to anonymise it by removing the labels.
Can this be done from the Chart Control, or do I need to do it at the underlying data-table?
View 1 Replies
Feb 10, 2011
I have a bar graph displaying a number of different series (stacked on each other) and I'm trying to find a way to dynamically change the y-axis interval if the values go above a set value.
If the bars only go up to a maximum of 50, I'd like the interval to be 25 so the bars still 'look' rather small. But if a large spike comes through, the interval needs to be set to 0 so the large spike is more noticeable.
View 1 Replies
Nov 1, 2010
How do I reduce the width of the left margin area shown below, marked in red?
View 1 Replies
May 10, 2012
I am using asp.net charts in my application, i have given the axis values from code behind. I added the on page load but the problem when i go directly to that page the graph will not appear but if i reload the same page it will appeare. this happens when i publish the application and try on IIS, but there is no problem before publish (while run in VS).
View 1 Replies
May 7, 2015
I would like to change the text of my X axis.
Look the below picture :
View 1 Replies
Jun 29, 2010
I am working with a chart control and on the Y axis i have numbers that fall between millions and billions.
The numbers on the axis themselves are not formatted and as such can be difficult to read. I wanted to know if there was a way for me to format the value that appears on the axis itself to be coma seperated?
here's what the Y axis looks like
600000000
300000000
100000000
numbers are just hard to read. How do i format them with coma's or even add a label saying (Millions) and then displaying only 100, 300, 600 etc
View 5 Replies
Aug 11, 2010
I have a .net3.5 mschart control bound to a data table displaying a line graph. I wigh to zoom in on an axis on an asp.net web form.
View 1 Replies
Nov 1, 2010
I like the way that the chart control seems to automatically determine the X axis range for me based on the data, but in this case, the data can only be whole numbers.
What is the easiest way to specify whole numbers for this axis?
View 2 Replies
Feb 11, 2011
how i can connect sql database to table control?
View 1 Replies
Sep 23, 2010
can i upload my pdf or word file to oracle/SqlServer database table ?
View 4 Replies
Apr 17, 2013
I want to display no. of rows a table contain from database on label, how can i do that..
View 1 Replies
Feb 24, 2010
how to freeze the x axis of the chart control in ms chart? need to use because data displayed at large amount that is scrollable.
View 1 Replies
Feb 18, 2010
implementing an file upload control that uploads the binary data to the database table and associates it with the correct user/the current user who uploaded the data.
View 8 Replies
May 7, 2015
I want to save three images path in table also upload images in folder,how it is possible?[Using ajax file upload control]table columns are imagepath1,imagepath2,imagepath3. URL....
HTML
<asp:AjaxFileUpload ID="AjaxFileUpload1" runat="server" AllowedFileTypes="jpg,jpeg,png,gif"
MaximumNumberOfFiles="3" OnUploadComplete="File_Upload"
Width="500px" />
C#
protected void File_Upload(object sender, AjaxFileUploadEventArgs e)
[code]....
View 1 Replies