Forms Data Controls :: Creating Custom Axis Format For Chart Controls?
Jun 7, 2010
i created a chart in Excel, but now I am having the time of my life to create the same chart in a control.
If you can see on the bottom I have converted the labels to percentages.
In excel I am using a series of data cells to create the bottom labels (0-8 with a .5 increment).
The Y-axis is done with a fixed maximum value of 2 and the labels are percentages as well. How do I get those same axes on the chart control?
View 1 Replies
Similar Messages:
Aug 13, 2010
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.
View 2 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
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
Aug 19, 2010
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 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
Sep 17, 2010
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?
View 4 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 17, 2010
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.
View 2 Replies
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.
View 1 Replies
Nov 17, 2010
i'm trying to create a stacked bar chart on a vb web form using vs2010.My data source returns:
Error in Functionality Awaiting on Supplier
1IMT IssuesmActive6
IMT Issues,Awaiting on Supplier
2,IMT Issues,Awaiting on User 4
IMT Issues Closed 120
Login / Password Active
But I can't get this into a stacked chart. I know I must have to do quite a bit of work declaring what the series are and soforth, or having a different dataset but can't find any documentation on it.A link to some documentation or an example of a stacked chart from an sql datasource would be much appreciated.
View 1 Replies
May 5, 2010
I am building a .net page and need to display some data residing in a database. Some of it's working, some not. I would like to use a table to display the data with the format below..
Table
row - question data
row - answer (count)
row - next answer (count)
row - BarChart representing the answer counts for question
row - next question data
row - answer (count)
row - next answer (count)
row - BarChart representing the answer counts for question
The question data and answer count rows are generated with no issue. However, the rows containing the barchart are problematic. Not sure how to create a new instance of a chart on the fly and hook in all the methods, etc. and get the control added to and displayed in the tablecell. Been looking for examples to create the chart on the fly with no real results.
View 7 Replies
Jan 17, 2011
I have what is turning out to be a rather complicated issue - at least for me.
I have a table with TeamID, TeamName, TotalTeamSize, ArrivalDate adn DepartureDate.
I need to create a source for a bar chart that will show the number of people deployed each month. It can be assumed that the entire team is dployed for each of the days between the ArrivalDate and the DepartureDate. Sometimes the ArrivalDate/DepartureDate spans two months (very rarely more) and sometimes it does not.
Here is what I have so far. In this setup phase, I thought I'd get the code working for one team (using a DropDownList) and then cycle through the entire table in order to get the full dataset for the bar chart.
[ASPX]
[Code]....
[VB]
[Code]....
View 4 Replies
May 21, 2010
I am stuck in chart controls...Here is my prob... There is a ListBox containing some items...when user selects multiple items from the list box I want to generate a dynamic table with the number of columns same as that of the number items selected in the listbox. And for each selected item I want to show a seperate chart in the columns...Currently I want the same chart control for every selected item (i.e. a static hard coded chart that i will replace later by dynamic values)....I am using a method that draws a chart control using a sample dataset... I am calling it each time when a new column is created..Also the DrawChart method executes for the first column only and throws an index out of range exception! after the first execution...my code is not working...here
my code...
[Code]....
[Code]....
View 1 Replies
Jan 31, 2011
Using C# and SQL server. I need to dynamically format a web page which is intend for reporting. I have 2 SQL tables. Projects ( Project ID and Project Name) and Subprojects ( SubprojectName, ProectID, EmployeeName, Decription). Subprojects are linked to the projects throughthe ProjectID field
Needed format;
Employee Name
All the project for that EmployeeName
All the SubProjects for that EmployeeName undre the given project + Description of the subproject
Eg:
Peter
Project A
SubProject AA <subProject AA Description >
SubProject AB <subProject AB Description >
SubProject AC <subProject AC Description >
Project B
SubProject BA <subProject BA Description >
SubProject BB <subProject BB Description
ANN
Project C
SubProject CA <subProject CA Description >
SubProject CB <subProject CB Description >
How can I achieve this?
View 4 Replies
Feb 4, 2010
I am creating a Data Tabel in code behind and binding it to Gridview. I am trying to format by creating new line in a single column. Here is the code:
row("Employee Name") = empName + ("<br/>" + empTitle
GridView1.DataSource = myDataTable
GridView1.DataBind()
View 3 Replies
Jul 26, 2010
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 Replies
May 7, 2015
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];
[Code].....
View 1 Replies
Apr 13, 2010
I have a some complex requirements, which doesn't seem to be meet by any of standard asp.net grids.
So I am planning to create my own grid control from scratch(generating own html). Any pointers on how/from where to start?
View 2 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
Mar 12, 2010
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.
View 5 Replies
Sep 9, 2010
My problem is that I have a different format table for each section in my form. And I would like to bind data to these tables. A repeater I don't think is going to work. It would be great if I can do it like this:
[Code]....
Where the "+ 1" is the next record from that datasource --which is bound in code behind. Is there anyway, I can accomplish this without resorting to dynamically created tables.
View 3 Replies
May 7, 2010
i am creating a total column which multiplies the price by quantity in my gridview but am stuck on converting the input strings.
The price is stored as a decimal in my database and the quantity is a nvarchar.
i am receiving this error:
Input string was not in a correct format.
Description:
An unhandled exception occurred during the execution of the current web request. review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.FormatException: Input string was not in a correct format.
Source Error:
[Code]....
heres my row databound event:
[Code]....
View 8 Replies
Jan 26, 2011
I recently got a form to work with the "HttpContext.Current.User.Identity.Name.ToString" String. That basic idea was I needed a hidden form field so that each record submitted would include the UserName of the user logged in to the membership. However, whenever I try to create a custom query for the gridview, it doesn't submit. how I would go about doing this? Code as below:
[Code]....
[Code]....
View 2 Replies
Aug 23, 2010
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 Replies
