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.
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 ?
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.
View 9 RepliesI am making a chart on a asp.net page (visual studio 2010). I am "summing" time. As long as the sum is not more than 24hours, all goes well. But if the sum is bigger than 24hours, then I get a "Not a legal Oleaut date" error.
This is my code (simplified) :
Chart1.DataBindCrossTable(_dataset._table.AsEnumerable(), "factor",
"week",
"time",
"");
Chart1.Series[0].YValueType =
ChartValueType.Time;
duurhhmm is a DateTime field. "factor" and "week" are my groupings for the x-axis.
first question : what to do about the "not a legal oleaut date" ?
second question : on the axis I see 00:00,06:00, 12:00,18:00 and then again 00:00,06:00, etc... But I would like to have 24:00, 30:00.
I have a fairly basic line graph which is bound to a SQLDataSource control. The graph displays perfectly, but I want the labels on the X-axis to display vertically rather than horizontally.
I have used the following code to try and do this but it is having no effect:
<AxisX Title="Patient Safety Submissions" IsLabelAutoFit="True">
<LabelStyle Angle="90" interval="1" />
</AxisX>
[code]....
May I know how to do this kinds of report? I am using Crystal Report 2008. Is it can be done using crystal report 2008? Is yes, may I know how to do this?
View 1 RepliesI have to display text values dynamically on Y-axis of a bar graph in Dunda charts.
Like Region 1, Region2 .....................
how can I do that?
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 have a Table in a reportviewer.
On the Vertical(row) axis i would like to display data from "Fields!REGCODE.Value".
I only want to display 3 rows at all times, namely the value for REGCODE "013", "015" and "Other" (all other values than "013" and "015") which is translated to "KK", "KA" and "Other".
I have made a Group that does the following:
=Fields!REGCODE.Value = 013
=Fields!REGCODE.Value = 015
=Fields!REGCODE.Value <> 013 and Fields!REGCODE.Value <> 015
I have also made the following Expression:
"=IIF(Fields!REGCODE.Value = 013, "KK", IIF(Fields!REGCODE.Value = 015, "KA", "Other"))" which works perfectly except when there for example is no content in "013", the row is removed. I want the three rows (KK, KA and Other) at all times, how do I do that?
On the Horizontal(column) Axis, I want to display town names. The Town names correspond to a number in "Fields!COLLECT_PLACE.Value" but I manually type in the town names to make sure that the columns is always shown and shown in the right order.
For each filed in the table i would like to make a count of the number of found values that has the corresponding REGCODE and COLLECT_PLACE.
For example for the following data:
[URL]
How do i make sure that all the 3 rows are alwais there, whether or not they contain data?
How do i count the right value for each table field and not the total row value in each field.
I am trying to put different tooltips in my MS chart (No in the points) I want these tooltips in my values in axis and I cannot do it.
View 3 RepliesI 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];
[Code].....
I would like to put 4 categories (fixed) on my chart (example: 1,2,3,4 quarter on the x-axis) and display data from the database in the right category.
// AVG correspond à moyenne et on multiplie par 100 puisque à la base la colonne est de type Decimal
string query = string.Format("select Entite, AVG(AvancementQuantitatifT1 * 100) FROM reponse WHERE ObjectifStrategique = '{0}' GROUP BY Entite", Objectif_strategique.SelectedItem.Value);
[Code].....Â
For example I want to do something like that :
select Progressquarter1, Progressquarter2,Progressquarter3, Progressquarter4 and put respectively in quarter 1 quarter 2 quarter 3 and quarter 4.
I want to display the multiline chart for comparing two or more employee attendance in asp.net ... I am trying but I didn't get exact solution ....
View 1 RepliesI 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 RepliesI 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 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 RepliesI 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,
i
i
x
i
I would like to have
i
i
i x
i
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):
1. SIEMP
2. SISOUT
3. SIGTI
4. SISFIN
5. SISPL
6. SISTER
But it´s only shows:
1. SIEMP
2.
3. SIGTI
4.
5. SISPL
6.
I must set a parameter that forces "all" series to be showed.
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 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.
Trying to follow this example: [URL]
I have a database with 4 columns, 3 of the columns are int (1-10) and the other is a "DateTime". I am trying to graph the 3 columns vs the DateTime(X-axis) on one line chart.
To add more than one y axis value I go to the Series property -> YValueMembers (notice the plural) and enter my 3 columns of the database (followed by commas) that I want on the Y axis.....but doesn't seem to work.
I get a run time error saying only 1 column is allowed on the Y axis.
Data points insertion error. Only 1 Y values can be set for this data series.
How do I get all 3 columns vs the 4th column on one line chart?
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.
View 1 RepliesI 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 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