Create A .net Chart Object With A Series Based On A Data Subset?
Apr 8, 2012
I'm working in VS2010 on a visual basic application. It takes in serial port data, writes it to an access database, and then graphs the data.The data only comes in once every minute, so it's not like I'm building an oscilloscope. Right now, the chart is reading from the database using a table adapter and graphing just fine, so long as I keep the number of records in the database low.If I add too many records to the database, the chart shows a red "X" through it. I've played with changing the axes, but it is still a problem.I don't really need to graph the whole database.The twenty most recent records would suffice.How can I make a chart series with only a small subset of the database in it.Perhaps it cold be populated with a query?
View 1 Replies
ADVERTISEMENT
May 12, 2012
I am trying to build a function that returns a chart. I want to have a parameter to account for times where i may need more than one series. How does one loop through to create multiple series? I would think you would need a variable for each series. The function is below. I would think that if there were 5 series that each of the "Dataseries" variables should have their own name. Do I then refer to them by index only?
[Code]...
View 1 Replies
Jan 15, 2009
I am trying to build a function that returns a chart. I want to have a parameter toaccount for times where i may need more than one series. How does one loop through to createmultiple series? I would think you would need a variable for each series. The function is below. I would think that if there were 5 series that each of the "Dataseries" variables should have their own name. Do I then refer to them by index only? Public Shared Function MakeChart(ByVal form As Form, Optional ByVal numseries As Integer = 0) As Chart
' Add any initialization after the InitializeComponent() call.
Dim SampleChart As Chart = New Chart()
Dim MainChartArea As ChartArea = New ChartArea()
[code].....
View 11 Replies
Jul 6, 2011
I am importing data from an excel file, and it is stored in a dataset. The data is then filtered with a binding source, and that data is outputted into a datagridview. The filtered data in the datagridview contains data for 2 identification numbers. I want to graph each ID number in a chart on their own bar, in either a stacked bar graph, or a double bar graph.
I am having trouble assigning each series to an ID number: I have tried using multiple binding sources, but each seems to override the previous giving too much/too little data. I have tried using multiple datagridviews, however I cannot assign more than one datagridview as the datasource for the chart. The code I have pasted below outputs a double bar graph, however both bars graph the same ID number.
Private Sub dataButton_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles dataButton.Click
Try
Dim cnRange As String = "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source='" & strFileName & "';" & _
"Extended Properties=""Excel 8.0; IMEX=1; HDR=No;"""
'moApp.Visible = True
[Code] .....
View 1 Replies
Jun 21, 2012
I have an array of type Double() (1 x n) that I am trying to quickly plot on a graph I've already set up. The only thing I want/need to do is take my array and store it as data points (y-axis values) in the series I already have. What's the best way to do this? Also, will the data points that are plotted change as my array changes, and if not, how would I replot those new points and get rid of the old points?
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
Nov 30, 2011
I think my subject sums up what I am interested in knowing. I am looking to create a chart where Series1 is from Table1, Series2 is from Table2 in the given Dataset. My code below doesn't throw any errors, but it appears to be grabbing the data for each series from the first table.
Imports System.Windows.Forms.DataVisualization.Charting
Public Class Form1
Public Sub New(ByVal ChartData As DataSet)
' This call is required by the designer.
InitializeComponent()
[Code] .....
View 1 Replies
Aug 25, 2010
I'd like to get suggestion in both C# and VB.NET I created Chart like the following image:
[Code]....
View 1 Replies
Mar 23, 2012
How do I dynamically add or remove a chart series on a WinForm. To date all my MS Charting experience has been dealing with ASP.Net charts with static sql select statment to a SQL Database. In the new project that I have been assigned I have different cities with different amounts of points that they want monitored. One city might have 3 an another might have 5 or 7 so I can't hard code the amount of series that I need. It needs to be set up so the amount of series can be flexible depending on the city selected and then display those points on the chart.
View 4 Replies
Apr 6, 2011
I am creating a project in VB.NET in which one of the reports require that the name of employees should be displayed as column names and whatever work they have done for a stated period should appear in rows below that particular column.Now as it is clear, the columns will have to be added at runtime. Am using an ODBC Data source to populate the grid. Also since a loop will have to be done to find out the work done by employees individually, so the number of rows under one column might be less or more than the rows in the next column.Is there a way to create an empty data table and then update its contents based on columns and not add data based on addition of new rows.
View 1 Replies
Jan 7, 2010
I am able to place a single series of chart data with my code but I cannot for the life of me figure out how to add a second series. I can add the Series ... I can Select the series but cannot with out errors figure out how to put data the the series' that I am creating ...
Ol' Mitch
xlApp.ActiveChart.SeriesCollection(1).Values = Rng1 <-- Error
xlApp.ActiveChart.SeriesCollection(2).Values = Rng2 <-- Error
[Code].....
View 2 Replies
May 9, 2011
I have a set of charts in a form. These are "canned" charts and will only be updated when new data comes in (typically on a monthly basis). I have created each chart by binding (bounding?) a data source to it in VS2010 using the Properties slide out window. I set the DataSource to a data source table that I set up in the .XSD file. In the Series property GUI I have set up the XValueMember and YValueMembers from the available columns in the data table I set in the previous step. I have 6 tables in my DataSet. One table relates to one Chart (Chart1, Chart2, Chart3, etc) in my form.
What I would like to do is programmatically get the data table name from the Chart properties. I have tried doing something like:
ch1Table = Chart1.DataSource.DataMember.ToString
However this fails due to Option Strict disallowing late binding. I am probably missing something obvious here but I cannot see it.
So, how do I get the bound data table name from the set properties of the chart? I am using MSChart Control 4 and VS2010 and building a VB.NET WinForms app.
For each of the 6 charts there is an associated System.Windows.Forms.BindingSource. What I need to do is programmatically get that BindingSource, then get the DataMember (which is the table name I need) for each chart.
View 1 Replies
May 17, 2011
Apply a generic template to chart series.[code]Note that the bars are unstyled while the chart seems to style just fine.The documentation regarding built-in .NET charting is woefully thin.Can anyone help me get my generic templates to work?
View 1 Replies
Jul 18, 2011
Im starting to learn how to use the chart control in VB .how you create a "new" column because atm all the time i add series it puts them side by side.Ive looked at the documentation for the control and the examples but they dont seem to cover this , or i could find it .Now how would i assign each series to a new point?So item 1 would go above column 1 and item 2 above column 2 etc.The code i have at the moment is a test code .
Chart1.Dock = DockStyle.Fill
For i As Integer = 0 To 10
Dim newSeries1 As New Series[code]..........
View 1 Replies
Mar 4, 2012
How do I plot multiple series (say about a thousand) on one chart at runtime?
View 7 Replies
Jul 19, 2011
Is there is a way to remove the white box around the series label in a chart. I am using the built in chart from the toolbox in Visual Studio 2010. This is the last part I need to finish the appearance of the chart to make it look the way I want.
View 1 Replies
Mar 17, 2012
I am using a button on a form which creates a chart at runtime when the user clicks the button. it works ok for the first time but when I select the button the second time I get a square diagonal box or indexoutofrange Exception.Note: I have another button that clears the series from the chart before reselecting the button that creates the chart.
Below is the code segment
Private Sub Button1_Click(sender As System.Object, e As System.EventArgs) Handles Button1.Click
Static Dim counter As Integer = 0
[Code].....
View 1 Replies
Apr 2, 2012
Im trying to plot the reading of 20 or more thermocouples in a single chart area.But it seems that the build in charting in vb.net can't handle that. My program just crashes when adding a series somwhere between the 14th or 18th series.Anyone know of any setting i can change or a better charting plugin?
View 2 Replies
Jan 7, 2011
imagine an array of data containing a gray scale image and you want the bar chart (say 20x20) to display a section of that image as both the magnitude of the data and its shade of gray. if you were to look vertically down on the 3D barGraph you should see the section of the image. Is this at all possible? The projetc relates to clutter intensity in a radar image if this interests you.
View 2 Replies
Jun 23, 2011
How do I link data in an Excel spreadsheet to a chart object in Visual Basic 2010? Really basic here, I just want to draw a single simple line chart from a single column of data. Is it easier just to read the data into an array (which I can do) and somehow get it into the chart?
View 1 Replies
Jun 23, 2011
How do I link data in an Excel spreadsheet to a chart object in Visual Basic 2010? Really basic here....I just want to draw a single simple line chart from a single column of data. Is it easier just to read the data into an array (which I can do) and somehow get it into the chart?
View 1 Replies
May 31, 2010
Ok, what I would like to be able to do seems simple enough. I would like to be able to create an Excel document with a series of columns that contain data to import into Visual Basic 2008
[Code]...
View 1 Replies
May 18, 2009
I have a program written in VB6/VB.net and its supposed to calculate a set of numbers based on user input. From there the data is saved into an xml file. I want to be able to take the data from the xml file and draw a chart representing all the data. I found a tutorial that draws line graphs based on an predetermined array of data, but I need the program to take the data from an xml file.
Heres the code for the line drawing program:
Option Strict On
Imports System.Drawing.Drawing2D
Public Class ViewChart
[Code]....
View 11 Replies
Sep 20, 2011
I have a bunch of objects, they aren't in XML but the xml document would look like this[code]...
The tree is obviously very deep. Does anyone have an algorithm to create this into a jstree, series of "UL" and "LI". It would be christmas if you had the code in vb...but I will be satisfied with just the logic. My thought is to eventually make this into a jsonp web service so I can use jstree to build a tree, but for now im just trying to understand the logic necessary to parse this correctly.
View 2 Replies
Jul 14, 2010
I have a bunch of objects, they aren't in XML but the xml document would look like this:
<object>
<path>root</path>
</object>
<object>
[code]....
The tree is obviously very deep. Does anyone have an algorithm to create this into a jstree, series of "UL" and "LI". It would be christmas if you had the code in vb...but I will be satisfied with just the logic. My thought is to eventually make this into a jsonp web service so I can use jstree to build a tree, but for now im just trying to understand the logic necessary to parse this correctly.
View 3 Replies
Feb 26, 2012
In VB.NET, I need to create an Image based on a Graphics object I have. However, there is no method such as Image.fromGraphics() etc. What should I do then?
View 2 Replies
May 26, 2012
Anyone have VB.Net or VBA code to ascertain if an Excel Object is positioned over (Hiding) spreadsheet data?I have code to create/position a chart object. Where would I begin to determine if there is data "under" an object.
View 7 Replies
Dec 29, 2011
I am working on an application that ties into a SQL database on the back end. Currently the main form contains a series of combo boxes (Graph type, data format, location, and customer), two date pickers, and a button to launch the selections in a new form. Everything works just fine except there are a couple of things I can't seem to accomplish.
Example Data:
[CODE]...........
Case Select (with commented out lines for variations attempted):
[CODE]..........
1) I would like to be able to use some sort of case statement to color the bars in my chart based on value. I have tried approaching this in a couple of different ways but neither of the options seem to work. First, I tried this (the If Not is used because depending on what values are passed to the stored procedure in SQL, different columns will be returned):
[CODE]..........
Only one series is created with this method, so I can see how/why a Select Case would set all bars the same color. I have also tried creating a series for each row in the returned dataset but it results in 22 bars of different colors, for each of the rows (484 bars):
[CODE]..........
So is there any way to modify the second set of code there to only select the value from the "Percent TMHB" cell that corresponds with Row(i), rather than ALL values from the "Percent TMHB" column for EACH Row(i)?
2) Since I am drawing/creating these graphs in a new window, is there any way to also create a new timer on the "newFrm" and have the tick refresh the data? I've struggled with this but I feel like it should be easy. Say someone chooses a "TMHB", "Percentage", "Chicago", "All" (Graph type, data format, location, customer) and launches the graph, which opens in a new window, then they want to do "TMHB", "Percentage", "LA", "All" and have both windows up, refreshing automatically throughout the day. Can I somehow store the SelectCommand.Parameters values in the new form/timer so that it will query the database again every 5 minutes?
Example code for the StoredProcedure and creating the new form:
If combo_GraphType.SelectedItem = "TMHB" Then
Dim newFrm As New Form
Dim newChart As New Chart
[CODE]..................
View 1 Replies
Jun 30, 2010
I am not sure how to phrase my question properly but I want to achieve something like this.
I have a class named Products public class Products
private ID as Integer
private Name as String
Public Property ProductID()
Get
Return ID
[Code]...
When I do the same, I am getting an error "Object Reference Not Set to an Instance of an Object.
View 1 Replies
Jun 2, 2010
I have an arraylist that holds a subset of names found in my database. I need to write a query to get a count of the people in the arraylist for certain sections i.e. There is a field "City" in my database from the people in the arraylist of names I want to know how many of them live in Chicago, how many live in New York etc.
how I might set up an sql statement to handle this. I think somehow I have to pass the subset of names to sql somehow.
Here is a sample how I am writing my sql in my code
Public Shared Function GetCAData(ByVal employeeName As String) As DataTable
Dim strQuery As String = "SELECT EMPLID, EMPLNME, DISP_TYPE, BEGIN_DTE FROM Corr WHERE (EMPLNME = @name)"
[Code]....
I need a way to create a function using your sql statement to return a datatable object of names and the parameters would be city, and the List of names.
The above example isnt the sql I am looking for its just a skeleton of what the function would look like that I want to create.
So then you would use the function by iterating through all the cities passing in the same set of names each time in the fron end.
View 5 Replies
