VS 2010 - Sort X Axis On MSChart With Multiple Series
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
Similar Messages:
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
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
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
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
Jan 22, 2011
I've created a pie chart with several slices from a databind with a database. now i want to be able to click on a slice and show the values behind the clicked slice from the database in a gridview.
View 2 Replies
Nov 26, 2010
I tried to place 4 mschart controls on the same page but it is giving me major grief. Each chart appears properly when I place one per page, but as soon as I place multiple the first two are displaying incorrect data and the last two do no display anything at all.
I made sure that I am not using the same session variable eventhough that seems to be the most like culprit.
View 1 Replies
Nov 20, 2010
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?
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
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
Nov 19, 2013
I have 3 columns of data that get returned from a stored procedure. Date, Error code,and Quantity. On one day we can have 8 different error codes, with different quantities.For example on the date of 18 Nov we had error code 101 = 24, error code 102 = 36, error code 103 = 4, etc. I am trying to display the different error codes in columnswith their quantity by date. There will be multiple columns for a given day because the error codes range from 101 -124. How can I display this? I currently have Just oneat a time being display based on which the end user picks.
If DS.Tables.Count > 0 AndAlso DS.Tables(0).Rows.Count > 0 Then
ErrorCodes.DataSource = DS
ErrorCodes.Series("Exceptions").XValueMember = "Error Date"
ErrorCodes.Series("Exceptions").IsValueShownAsLabel = True
ErrorCodes.Series("Exceptions").YValueMembers = "Total"
[code]....
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
Sep 3, 2010
I'm currently developing a website that shows multiple charts that I build using data from SQL tables. I've used and followed Scott Mitchell's tutorial [URL] and K. Scott Allen's ChartBuilder class [URL] and all works well.
However when have two series that I want to show on the same Chart, if one set of data does not have all of the X values the other series does, the chart blindly puts all the data on, ignoring trying to match the X values of the other series, therefore mismatching the X values when the chart is shown.
I know that I can fiddle the data so that both sets of data have the same X values, however I'm trying to make the class handle anomalies in the data so that I don't have to worry too much about the data.
View 1 Replies
Mar 9, 2011
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:
[code]....
View 1 Replies
Jul 17, 2015
I need to generate barcode series to print on label.
Below thread is working fine to generate single barcode.
[URL]
How can i create barcode series and print. i.e. from 0001-0100
View 1 Replies
Mar 11, 2010
i am using .net framework 3.5 and visual studio 2008, i want to develope an application
for graphs and charts, so charting control 3.5 i am using.
i want to add multiple series of charts on a same chart which are at different location.How can i do it?
View 1 Replies
Mar 8, 2011
[URL]
i m not able to download the
Built-in Charting Controls (VS 2010 and .NET 4 Series)
View 3 Replies
Feb 22, 2013
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 Replies
Jan 5, 2011
I am a novice programmer using ms chart control for my dashboard, I have a problem displaying chart series.
Here is my sample query & result
Sample Query: "SELECT Brand, sales, Manufacturer From TABLE"
Sample Result:
[code]....
How can I display BrandA for XValueMember & Salesvalue(10000) for YValueMembers as Series1 having a column chart type.
And to display BrandY & BrandZ for XValueMember ; Salesvalue for YValueMembers as Series2 having a line chart type.
I want my chart to have 2 Y-axis; Series1 for primary Y-axis & series2 for secondary Y-axis.
My problem here is how can I display BrandA in Series1 and BrandY,BrandZ in Series2 where the values are in the same field?
Or is it possible to set more than one data source for the chart control?
I've been working on this for two days but I wasn't able to get the desired result.
View 1 Replies
Feb 25, 2010
Ive an page with listview.. i'm performing sorting in itemdatabound event like below:
[Code]....
and my listview looks like this:
[Code]....
I want to sort with multiple columns.
View 5 Replies
Jan 4, 2010
wondering if someone can possibly help me out with a gridview. I have data coming into a grid and I know how to filter the data using one dropdown, I'm trying to get a little more advanced now. I'd like to filter using three dropdowns.
This is what I have so far: I don't know how to hook the downlists to the query?
<asp:DropDownList runat="server" id="DropDownList1" Width="90px">
<asp:ListItem Value="item_num">Item #</asp:ListItem>
<asp:ListItem Value="lot_num">Lot #</asp:ListItem>
<asp:ListItem Value="production_code">Production Code
</asp:ListItem>
<asp:ListItem Value="batchcode">Batch Code</asp:ListItem>
<asp:ListItem Value="inbound_no">Inbound #</asp:ListItem>
<asp:ListItem Value="recv_date">Received Date</asp:ListItem>
<asp:ListItem Value="location">Location</asp:ListItem>
<asp:ListItem Value="category">Category</asp:ListItem>
</asp:DropDownList>
<asp:DropDownList runat="server" id="DropDownList2" Width="160px">
<asp:ListItem Value="=">is equal to</asp:ListItem>
<asp:ListItem Value="<=">is less than or equal to
</asp:ListItem>
<asp:ListItem Value=">=">is greater than or equal to
</asp:ListItem>
<asp:ListItem Value="<>">is not equal to</asp:ListItem>
<asp:ListItem Value="begins with">Begins With</asp:ListItem>
<asp:ListItem Value="Like">Ends With</asp:ListItem>
</asp:DropDownList>
<asp:TextBox runat="server" id="TextBox1" Width="150px">
</asp:TextBox>
<asp:Button runat="server" Text="Go" id="Button8" BackColor="Lime" />
<asp:Button runat="server" Text="Clear Filter" id="Button9" /><br />
<input name="Checkbox1" type="checkbox" /><label id="Label5">
Include Items containing "Zero on Hand" Quantity.<br />
Group by Fields: <input name="Checkbox2" type="checkbox" />
Item/Lot
<input name="Checkbox3" type="checkbox" /> Production Code
<input name="Checkbox4" type="checkbox" /> Batch Code</label><label id="Label4"></label><br />
<hr />
<asp:GridView runat="server" id="GridView1" AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Font-Size="Small" BorderStyle="None" BackColor="White" GridLines="Vertical" BorderColor="#999999" BorderWidth="1px" CellPadding="3" Font-Underline="False"
AllowSorting="True" AllowPaging="True" PageSize="20">
<RowStyle BackColor="#EEEEEE" ForeColor="Black" />
<Columns>
<asp:boundfield DataField="STATUS" HeaderText="Status" SortExpression="STATUS">
</asp:boundfield>
<asp:boundfield DataField="ITEM_NUM" HeaderText="Item #" SortExpression="ITEM_NUM">
</asp:boundfield>
<asp:boundfield DataField="LOT_NUM" HeaderText="Lot #" SortExpression="LOT_NUM">
</asp:boundfield>
<asp:boundfield DataField="LOT_EXT" HeaderText="Lot Ext" SortExpression="LOT_EXT">
</asp:boundfield>
<asp:boundfield DataField="RECV_DATE" HeaderText="Recv Dt" SortExpression="RECV_DATE">
</asp:boundfield>
<asp:boundfield DataField="PRODUCTION_CODE" HeaderText="Prod Code" SortExpression="PRODUCTION_CODE">
</asp:boundfield>
<asp:boundfield DataField="QTY_ONHAND" DataFormatString="{0:NO}" HeaderText="OnHand" SortExpression="QTY_ONHAND">
</asp:boundfield>
<asp:boundfield DataField="QTY_RESERV" HeaderText="Reserv" SortExpression="QTY_RESERV">
</asp:boundfield>
<asp:boundfield DataField="QTY_AVAIL" DataFormatString="{0:N}" HeaderText="Avail" SortExpression="QTY_AVAIL">
</asp:boundfield>
<asp:boundfield DataField="QTY_ADJUST" HeaderText="Adjust" SortExpression="QTY_ADJUST">
</asp:boundfield>
<asp:boundfield DataField="QTY_SHIP" HeaderText="Shipped" SortExpression="QTY_SHIP">
</asp:boundfield>
<asp:boundfield DataField="QTY_RECV" HeaderText="Recv" SortExpression="QTY_RECV">
</asp:boundfield>
<asp:boundfield DataField="PROD_DATE" HeaderText="Prod Date" SortExpression="PROD_DATE">
</asp:boundfield>
<asp:boundfield DataField="RELEASE_DATE" HeaderText="Release" SortExpression="RELEASE_DATE">
</asp:boundfield>
</Columns>
<FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
<PagerStyle HorizontalAlign="Center" BackColor="#999999" ForeColor="Black" />
<SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
<HeaderStyle BackColor="#000084" ForeColor="White" Font-Bold="True" />
<AlternatingRowStyle BackColor="#DCDCDC" />
</asp:GridView>
<asp:SqlDataSource runat="server" id="SqlDataSource1" ConnectionString="<%$ ConnectionStrings:RemoteRooster %>" SelectCommand="SELECT * FROM [INVENTRY] WHERE OWNER = 'CompanyName' AND QTY_ONHAND > '0'">
</asp:SqlDataSource>
View 8 Replies
Jun 3, 2010
I have a simple dynamic gridview with following code -
GV = new GridView();
View 3 Replies
Mar 7, 2010
Actually i want to ask which is the best for sorting in Asp.Net is it DataView.Sort Method or List<Object>.Sort() method.
View 1 Replies
Apr 20, 2010
I'm looking for a way to sort the rows of a datatable without setting the DefaultView.Sort to a specific column. I have a datatable in session that users can add records to. I want them to be able to sort the data by clicking on a button. But new records added after that need to show up at the bottom of the list until the sort button is clicked again.
View 2 Replies
Sep 23, 2010
Just spent about 8 hours googling and looking through this forum for a solution on how to make sure that I can dynamically sort. Here is the situation.
I have 1 Gridview that displays 10 different scenarios based on what button is clicked.
I am also returning only top 10 records. I am doing all of the data binding pragmatically. So I have BoundFields, HyperLinkFields etc.
I also want to sort some records. When I change DataSource SQL statement the gridview somehow remembers what the last sort value was and it errors out saying that value "x" cannot be sorted because it does not exists.
I tried this:
Tried setting gridview1.sqldatasourceid = null; gridview1.allowsorting = false; gridview1.databind();
Here I get an error that says that the data source does not support sorting? Doesnt it say gridview1.allowsorting = false;
I also tried gridview1.sort("", SortDirection.Ascending); This does nothin... except query my database one more time because i have a onSorting event that looks like this:
[Code]....
Here is an example of just one of those SLQ statements inside GetSQLQuery:
[Code]....
View 1 Replies
