Charting - Ms Chart Multiple Series X Value Mismatch?
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
Similar Messages:
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
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
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
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
Aug 12, 2010
I am using MS Chart control (3.5), and have a requirement where I need to display 2 pie charts. The datapoints for the pie charts is set programatically. My doubts are as follows:
1. Can I display both the pie charts in a single chart control and area, or do I have to use two controls? (Currently I am using two controls)
2. How can I maintain the same size for both the pie charts? This is my main concern, since the pie sizes keep changing, depending on the number of datapoints. I tried using custom properties like "MinimumRelativePieSize", but it's not working.
View 1 Replies
Jul 17, 2010
Any body worked with MS Charting control for VS 2008.
I am using the chart control to displaying marks secured by students in different exams.
Series of the chart can be dynamically generated.
View 1 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
Mar 8, 2011
[URL]
i m not able to download the
Built-in Charting Controls (VS 2010 and .NET 4 Series)
View 3 Replies
Mar 15, 2010
I am plotting a chart using charting control. The x-values are text values and y values are date values.
If there is same text multiple times, then the plotted chart has multiple bars of same value. I want the values for the same text to be on the same bar.
View 2 Replies
Mar 18, 2010
I want to create multi series asp.net chart in dynamically.I am new one for this concept.
View 1 Replies
Jan 7, 2011
I 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.
View 5 Replies
Jan 11, 2010
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?
View 1 Replies
Jan 13, 2010
Is it possible to show the chart like the image in my attachement in Column Chart and in 100% Stacked Column Chart of SSRS 2008.
I like to show two series in same chart. Is it possible in SSRS 2008?
I provided the sample data to test it.
Select 'Fruits' as Category, 'Apple' as Item, 20 as Sales UNION
Select 'Fruits' as Category, 'Orange' as Item, 20 as Sales UNION
Select 'Snacks' as Category, 'Biscuits' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Chips' as Item, 10 as Sales UNION
Select 'Snacks' as Category, 'Cakes' as Item, 40 as Sales
View 3 Replies
Dec 19, 2010
I'm trying to bind a data table like:
month value
5 345
10 1300
12 450
to an ASP.NET Chart control. My problem is that the data table only contain months that have values while in the chart i want to show the full month range from 1st to the 12th.
So i used :
Chart1.ChartAreas["ChartArea1"].AxisX.Minimum = 1;
Chart1.ChartAreas["ChartArea1"].AxisX.Maximum = 12;
But when i do this, a part of the final series gets cut off in the middle like this.
I can avoid this issue by making the maximum 13 but that would not be appropriate since i just need to show the months of the year.
View 2 Replies
Jul 13, 2012
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?
View 5 Replies
Dec 6, 2013
I want to create line chart that shows Daily and last Month result in it (line chart)
View 1 Replies
Apr 27, 2016
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]...
View 1 Replies
Jun 16, 2015
i have readed your post(html5 canvas chart using asp.net)
and now i want to create line chart of chart.js
View 1 Replies
May 7, 2015
How to make multi columns with iTextSharp or fusioncharp reports.
View 1 Replies
Jul 14, 2010
I 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 Replies
Aug 30, 2010
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 Replies
Feb 25, 2010
I 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]....
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
Mar 28, 2011
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]....
View 1 Replies
