Forms Data Controls :: Chart Setting Number Of Points On Y Axis?
Feb 17, 2011
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.
I have a chart with Y1, Y2 and X.X is date time.Issue is first and last point of the line chart is plotted on the Y1 and Y2 axis. They do not leave any space.I would like to leave some space before and after each series (some distance from Y1 and Y2).So instead of this,
In 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?
My application work in this ways. I got a database collect data from 20 sensors. Database holds Temperature and DateTime data/Records from sensors. So i would like to make it whenever i view the chart, it will plot a line chart one by one according to the temperature and timestamp(DateTime). Which mean my X axis is a colleborate time on that particular date.I already design a in the way that the line chart will plot base on both dropdownlist, Sensor ID and Date. So it will work like whenever i select a Date or ID it will read the records from database table temperature.
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?
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
I have 2 series in the same chartarea. Both contain values by year (x axis). The problem is if one series does not have data for a given year, the chart will display the first value in a series on the first tick mark whether it matches the xaxis label or not.
Example:
[Code]....
Notice the 2009 value for series1 appears in the first column and the Xaxis now has 2 2009 tick marks. How do I get the values to appear on the correct X axis marks?
I´ve got a chart control (column type) and must show many elements at y axis, but when system generates the chart draw, it´s shows only odd elements: For example: My chart must show a colunm containing systems (x) and error incidences (y):
I am trying to create a chart with three x-axis labels where the chart series x-value member is a date. That is, each data point is a day returned from a SQL Server table. The first label row is to be the day component, the second label row the month name component and the third label row the year. The returned dataset can be from any time period and of varying length. It needs to look like below so each day can be seen but the bigger picture is also shown.
x-axis label(0): 26 27 28 29 30 31 1 2 3 4 5 6
x-axis label(1): March April
x-axis label(2): 2010
I can set the first row using the design time properties as such
[Code]....
I am not sure how to create the next to custom labels at runtime. I have gone through the options using Add(Double, DateTimeIntervalType, Double, Double, String, Int32, LabelMarkStyle) and Add(Double, DateTimeIntervalType, String, Int32, LabelMarkStyle) but I just cannot get them to appear in the chart label.
I tried the other method [Code]....
however could not find how to set the DateTimeIntervalType on the CustomLabel object.
There was nothing in the ChartSamples and I am not even sure if it can be done.
I 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:
I am using asp chart (framework 4.0) in one of the web page.
Chart displays x and y points from database.I want to fix the scaling of only Y-axis i.e., between 1 to -1as y axis point will lie within 1 to -1, as below:
10.750.500.250Â Â Â Â Â ------------------------------------------------0.25-0.50-0.75-1
C# code:
Chart1.Visible = true; string id = Request.QueryString[1].ToString(); string query = "SELECT x,y from Table where ID= '" + id + "' and DeletionDate is null"; DataTable dt = GetData(query);
string[] x = new string[dt.Rows.Count]; double[] y = new double[dt.Rows.Count];
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).
I'm having problem with MS Chart chart type column. If there are only 9 bar in the chart like the following picture, then the axis-x label show up properly.
However, there are more than 9 bars bar the chart, the axis-x label wont show up properly, some of them just dissappear.
Here's my mark-up for the chart:
[code]....
I don't know it works with only 9 bars? Is there any way to make the chart work properly? Also, if possible, how to make each bar have different color.
I am trying to set history points for a form that posts to a second page. Both the first page and second page are content pages in a master page.The form is in an update panel and consists of several textboxes, one radiobutton group of two radiobuttons and one ajax calendar control. The last two textboxes are a zipcode box and a county box. The county box is populated from a database table when the user fills in the zipcode in a textbox and tabs out or clicks in the next textbox.
How do you adjust the formatting of the asp.net point chart? I'd like to dynamically set maximum and minimums based on data in a List<>. I'd also like to figure out the properties that allows me to tweak the intervals within each of the axes and also formatting the labels so that I can change decimals to percentages.
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.