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?
View 2 RepliesI 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]....
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?
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 am using the Chart control that is part of the newest version of ASP.NET. In this Chart, I have 3 Spline series. Each series consists of a nullable in array (int?[]). If the element in the array is a number, I wants it point plotted. However, in the case that the value is null, I do not want it plotted. Is there a way to do this? If so, how?
View 1 RepliesI need to defining the Series parameters for an MS Chart.
Using the sample data below is it possible to set the X & Y value types for a graph with all days for the month on the X axis and the total number of visits for each day on the Y. Are MS Charts capable of auto generating the X axis based on the extents of the data dates as well a counting the daily instances?
[code]....
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?
Column Chart not showing both series when value is 1
I am having trouble displaying a stacked bar chart with a Y-Value of 1.
See the mark-up below:
The first Y-Value of the first series (the RED series) is 1. The first YValue of second series (the BLUE series) is also 1. The chart only shows the blue series. If I swap them around in the mark-up it only shows the red.
The last value (when X is 6) is 2 for both series. The charts will show both colors for the value of two. I would like this behavior when the value is 1.
[code]....
I've created a stacked bar chart - so there are multiple series in a line. The series display the value, but when the value is 0 I don't want the value to be displayed because if there are multiple 0 value is starts to look like 0|0|0|0 i.e. not very nice on the eyes. I'm wondering if there is a way i can say if the value of the series is 0 dont display the value.
View 1 RepliesI am having trouble displaying a stacked bar chart with a Y-Value of 1.
See the mark-up below: The first Y-Value of the first series (the RED series) is 1. The first YValue of second series (the BLUE series) is also 1. The chart only shows the blue series. If I swap them around in the mark-up it only shows the red.
The last value (when X is 6) is 2 for both series. The charts will show both colors for the value of two. I would like this behavior when the value is 1.
<asp:Chart ID="Chart1" runat="server">
<Series>
<asp:Series Name="SeriesRed"
ChartType="StackedColumn" Color="Red">
[Code]....
I've got an issue with the postback property. I have a chart (Code below) which has two series pulled from a datasource.
Both series display fine but I've enabled the bars in the chart to respond to the click event and when items from the first series is selected, everything works fine. However, I try to pull the x value for the second series, which is supposed to be a date, but all I get is an interger.
[Code]....
C# Code...
[Code]....
how we can make Multi- series 3D column chart using ASP charts
View 4 Repliesi 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?
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.
I am using Chart control to loop through and fill from GridView and it works fine.
Code:
myProductSeries.Points.AddXY(GridView1.HeaderRow.Cells(i).Text.ToString, GridView1.Rows(0).Cells(i).Text.ToString)
My question: How would I do that using a DataTable instead, is that possible. Does DataTable have a "Header" like GridView so do I fill the X value?
I want to create line chart that shows Daily and last Month result in it (line chart)
View 1 Replies I want to display line permanently in Y axis in stacked chart , limitation is 3000 and now i am displaring yearly value ,i want make two column for one year value display 1.Total 2.total sales of the all the mobile.
Code :
protected void Page_Load(object sender, EventArgs e) {
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[] {
new DataColumn("Apple"),
new DataColumn("Nokia"),
new DataColumn("Samsung"),
new DataColumn("Sony"),
[code]...
i have readed your post(html5 canvas chart using asp.net)
and now i want to create line chart of chart.js
How to make multi columns with iTextSharp or fusioncharp reports.
View 1 RepliesI have data in data table like below.
I am trying to make graph like below using asp.net chart control (made graph in excel with some test data)
points are X and Y values. lines are linear, exponential, logarithmic and power values.
how can I make this chart in asp.net (vb.net or c#)? I am newbie to chart control.
I have line chart which has values :
[code]...
when we set IsValueShownAsLabel=true on y-axis it shows value 0.
but graph showing values below zero at last 0.00 before 327.78.
Because I m new user cannot upoad image have a look Chart image from below url: [URL]
I want to create multi series asp.net chart in dynamically.I am new one for this concept.
View 1 RepliesI am creating a column and line chart in the same chart using reportviewer 2008.
The chart got two y series 'Number of product order' as column chart and label on left side of chart (unit number count) and total value of orders as line chart with label on right side of chart (unit $ value). Month is on x axis. I am wondering whether it can be done in reportviewer.
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.
I'm going through the ASP.NET chart controls WebSamples project but I haven't found what I'm looking for yet. So basically if I had a standard bar chart with data such as below:
John - 68%
Fred - 75%
Mary - 32%
Anne - 88%
Displaying it in one series with names as the x axis and percentages as the y, is there anyway to change or highlight the bar colour of just one, so say all the bars in the series are blue but I want to programmatically change mary's bar colour to red. Is this possible?